Forum Discussion

harry6810's avatar
harry6810
Copper Contributor
Mar 08, 2024

Sort Order Within a DAX Measure

Hi,

I have two main datasets connected by relationships through separate tables for specific features. Is there any way to sort my power pivot from highest to lowest value with using measure? Excepted result as below. 

 

 

excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Mar 08, 2024

    Hi harry6810 

     

    DAX Measures perform calculations, that's it. Presentation, design, sorting... is PivotTable's job

     

     

    With the above example: Right-click on a Customer > Sort > More Sort Options...

    • harry6810's avatar
      harry6810
      Copper Contributor
      Mar 08, 2024

      LorenzoIf you have one column it's pretty obvious. I have 9 and each one comes from a different table. Standard and advanced sorting options do not work.

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Mar 09, 2024

        harry6810 

        That's not clear which kind of aggregation do you have. If to sort row labels you may sort them one by one, each next sort will be within previous label group. In general the same is for values, it's within aggregated group.

Resources