Sort Order Within a DAX Measure

[harry6810]

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. 

[#2]

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...

[#3]

@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.

[#4]

@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.