Forum Discussion
Need help with Measure for Matrix Table and Top 5
Have you tried sorting by the sum measure in descending order?
I would go for:
Ref =
[Sum of Total Gross Incurred] * 1000000000000 + COUNT(LossRunToExcel[Reporting Location City])I got the first example to work in main file. Thank you for all the help. I will need more time this weekend to try the more creative and visual 2nd option.
Yes, it's definitely an issue in the service. You need to sort by the city field to get the axis to respect the structure:
It actually emulates the problem we used to have in Desktop when you turned off concatenate fields: for the setting to take effect, you needed to sort the axis by the fields:
It might be worth reporting the issue on the issues forum:
Have you tried sorting by the sum measure in descending order?
Yes Thank you so much.
How would you tweak the two measures If I have a page where Sum is looked at first and tie breaker would be count?
Top 5 by Frequency and Incurred measure would be easy to swap out Sum of Total for Count of Total but what abour Ref?
Ref =
COUNT(LossRunToExcel[Reporting Location City]) * 1000000000000 + [Sum of Total Gross Incurred]I would go for:
Ref =
[Sum of Total Gross Incurred] * 1000000000000 + COUNT(LossRunToExcel[Reporting Location City])Thanks again for the work.