0

Sequential sorting of a single dimension by multiple measures

Hello everyone, 
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.
Cheers, Dave 

2 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 8 mths ago
    • Reported - view

    Hi Dave,

    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.

    Ian

      • Dave_Carbery
      • 8 mths ago
      • Reported - view

      Ian Macdonald thanks for the reply Ian and the insight wrt future capability, much appreciated. 
      All the best, Dave

Content aside

  • Status Answered
  • 8 mths agoLast active
  • 2Replies
  • 36Views
  • 2 Following