Sort a hierarchy using multiple measures
I feel this should be straightforward but struggling to implement. I would like to sort a hierarchy by multiple measures, so that there is a primary measure used for sorting, a secondary measure and so on. Anyone have an idea of where to find some documentation to achieve this.
In Sort Wizard / Sort Targets you can do the multiple sort by select the measures based on your choice.
Hope this is the one you are looking for.
Consider the option to create a special sort measure that will be based on the other measures and produce the needed sort order.
[Sort measure] = [measure A] * 10000 + [measure B] * 100 + [measure C]
and use [Sort measure] in the sort.