Forum Discussion

azaterol's avatar
azaterol
Helper V
4 years ago
Solved

Sort the Sale

Hello everyone,

how can I sort the result in descending order? The one with the most sales should be at the top.

 

Here is my DAX:

 

total sale = CALCULATE(Document[sale],ALLSELECTED(customer[name]))

 

 

So in this case it has to be this order:

Mike
Tom
Ashley

 

 

 

1 Reply

  • azaterol , If want to sort the data for legend based on a measure that is not possible. But you can create a tooltip page and there you can sort the table on measure, do not pass legend value

     

    Power BI Tooltip Page: How to pass selective values to the tooltip page: https://www.youtube.com/watch?v=lEq7YtkxeLU