Measurement-based table classification

[Anonymous]

Hello everyone. I have a situation like the following:
Table sales, I already have a measure A to calculate % Different by week / month already.
How can I rank the customer in Table Sales based on %Different provided by A (such as Customer A with 40%, B with 20%, C with -10%) then A will be 1st and C will be the 3rd.

Thank you all. Stay healthy.

[Greg_Deckler · Accepted solution]

Hard to be specific. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That said, take a look at To *Bleep* with RANKX: https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/td-p/1042520

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may also take a look at the post below.

https://community.powerbi.com/t5/Desktop/Sorting-by-multiple-columns/m-p/536884#M251918

[Greg_Deckler · Accepted solution]

Hard to be specific. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That said, take a look at To *Bleep* with RANKX: https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/td-p/1042520