Forum Discussion
harry6810
Mar 08, 2024Copper Contributor
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? Except...
Lorenzo
Mar 08, 2024Silver Contributor
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...
- harry6810Mar 08, 2024Copper Contributor
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.
- SergeiBaklanMar 09, 2024MVP
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.