Below is an example of what I'm hoping to do. Please let me know if you require further clarification!
Form No. Rank
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!
Go to Solution.
The following DAX seems to work fine.
RANKX ( Table1, Table1[Form No. ],, ASC, DENSE )
I am using the "Dense" parameter with the RANKX function, but I'm still getting very weird rankings for duplicate values.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.