RANK.EQ

Question

Below is an example of what I'm hoping to do. Please let me know if you require further clarification!&nbsp;Form No.&nbsp;1293121254181835&nbsp;RESULT&nbsp;Form No. &nbsp; &nbsp; Rank12 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 112 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 112 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 118 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 218 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 235 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 354 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 493 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 5&nbsp;I tried using the RANKX and the RANK.EQ functions, but they both give different ranks to the "same" value. Any ideas/suggestions (in DAX code) would be very much appreciated!

v-chuncz-msft · Accepted Answer

zelda88,
&nbsp;
The following DAX seems to work fine.
Column =
RANKX ( Table1, Table1[Form No. ],, ASC, DENSE )

&nbsp;

Forum Discussion

RANK.EQ

2 Replies

Related content

Difference between RankX and Rank.EQ

RANK.EQ If statement ignoring 0

Re: TOPN function in CALCULATE

Re: Rank by Date & Time

Rank AVG for the data subset