Sequential sorting of a single dimension by multiple measures
I am trying to ascertain whether I can sort a table on a single dimension column but apply sequential sorts using more than one measure. This of this as a football league table where points are the initial sorting mechanism, and is teams are equal then a sort of teams using goal difference, and in turn, goals scored.
I feel like this should be possible, admittedly based on some common and popular tools. Having this confirmed one way or another would be useful.
The simple answer is yes and no!
If you are connected to an MDX source (SSAS OLAP, Tabular or SAP BW) then the answer is yes. It will require scripting a dynamic list through Formulate in MDX, but here's an example:
Note the Quantity sorted correctly within Returns value of 5 and 4.
ORDER(ORDER(DESCENDANTS([Manfucaturer].[Manufacturer].[All], [Manfucaturer].[Manufacturer]),[Measures].[Quantity],BDESC), [Measures].[Returns] , BDESC)
If you are connected to other sources using PQL to define the ordered list, then currently the answer is no. We are researching this currently and hope to add this capability in the future.
Hope that helps.