In performace point we have a scorecard, with different current month scores for each sales agent ex: profit, number of deals etc.
We want to add a score that will display if the agent had deals with all stores in period. We have a store dimension, but how can we check if all stores were used in the period for that agent?
We could add distinct count of stores. But how can we get the overall number of stores as a target?