Forum Discussion
Rank multiple measures each with different calculations
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.
Hi johnt75 I want to show all of the measures in the switch statement in order to find the Top N of all those measures together, the user doesn't want to choose specific KPIs in this report.
I don't see how you can that without massively impacting on performance.
Do the KPIs need to dynamically adapt to slicers or filters? If not, you could precompute them, and the TOPN, in a calculated column or table. You would still get a performance hit during data refresh, but performance for the end users should be fine