I created a calculated field from a parameter containing all my metrics I want to look at using this function:
CASE [Choose Measure]
WHEN "Average Duration of Use (min)" then AVG([Average Duration of Use (min)])
WHEN "Average Duration per Day (min)" then AVG([Average Duration per Day (min)])
WHEN "Average Usages per Day" then AVG([Average Usages per Day])
WHEN "Total Duration (min)" then SUM([Total Duration (min)])
WHEN "Total Usages" then SUM([Total Usages])
[Choose Measure] is my parameter. So I named my calculated field "Show Parameter Metrics" and dragged that to the columns part and I have various divisions of our company I want to look at by each measure. Is there a way the sort can be applied from greatest to least for all metrics? I'm trying to put this in my dashboard. I go to sort one measure but then when I toggled between my metrics with the parameter control, the order changes. I cannot figure this out and if anybody can help that would be awesome. Thanks guys!
Do you have a sample packaged workbook - just 10 or so rows of each measure is all that's needed so we can understandt the sort behavior. I typically utilize the rank() function to get a sort to work the way I want in situations like this. Ranking on the measure value created by the Case statement.