Forum Discussion
RankX - Unique ranking for Duplicate Values
ViralPatel212 , use new rank or rownumber function
Rank
RANK(DENSE, ALLSELECTED(cp[counter_party]),ORDERBY([Ranking Size (Vol)],DESC,[counter_party]) )
Rownumber
ROWNUMBER(ALLSELECTED(cp[counter_party]),ORDERBY([Ranking Size (Vol)],DESC))
Power BI - New DAX Function: RANK - How It Differs from RANKX: https://youtu.be/TjGkF44VtDo
Rownumber- https://www.youtube.com/watch?v=yS9-IQjUDwg&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=1
Your solution is worked amitchandak
Hi, ViralPatel212
Based on the screenshot information you provided, I can't download your report because I can't download it. I've created this example data below:
There will indeed be duplicates using the formula you provided:
The expressions provided by Super User work perfectly:
I've provided the PBIX file used this time below.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.