Forum Discussion
JohnShepherdAPD
Helper II
4 years agoRank multiple measures each with different calculations
I have a list of 53 measures that each have a unique calculation but the result of which can be compared to the other measures, I would like to find the Top N amongst these measures KPIPerfSales...
- 4 years ago
Instead of having the measure with the huge switch statement in it, create a new fields parameter and add all of the individual measures to that. when a user chooses which measure they want from the slicer it will only calculate the selected value, not all of them.
rather than having the current measure in the TopN filter and in the matrix, you would use the fields parameter.
JohnShepherdAPD
Helper II
4 years ago