Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Rank without date

Hi Everyone! I have a table that looks like this, I want to crear a Rank calculated column based on the batch number, for example batch no. a001 will be 1 and so on the result have t...

Tutorial Requests

amitchandak
6 years ago
Anonymous , Try like

rank = rankx(all(Table),[batch],,asc,dense)

OR For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

Super User

6 years ago

Anonymous , Try like

rank = rankx(all(Table),[batch],,asc,dense)

OR For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415