Rank without date

Question

Hi Everyone!&nbsp;I have a table that looks like this,&nbsp;I want to crear a Rank calculated column based on the batch number, for example batch no. a001 will be 1 and so on&nbsp;&nbsp;the result have to be like that:&nbsp;batch&nbsp; &nbsp; &nbsp; &nbsp;measure&nbsp; &nbsp; &nbsp; &nbsp; ranka001&nbsp; &nbsp; &nbsp; &nbsp; 23.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1a001&nbsp; &nbsp; &nbsp; &nbsp; 22.9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1b001&nbsp; &nbsp; &nbsp; &nbsp;24.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2b003&nbsp; &nbsp; &nbsp; &nbsp;23.9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp;&nbsp;I will appreciate some help!&nbsp;Kind RegardsChristian&nbsp;

amitchandak · Accepted Answer

Anonymous , Try like
rank = rankx(all(Table),[batch],,asc,dense)
&nbsp;
OR For Rank Refer these linkshttps://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measureshttps://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columnshttps://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finalehttps://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

Forum Discussion

Rank without date

1 Reply

Related content

Duplicate ranking

Ranking KPI card

Rank with conditions

Dynamic Ranking

What are community ranks?