Forum Discussion

ViralPatel212's avatar
ViralPatel212
Resolver I
2 years ago
Solved

RankX - Unique ranking for Duplicate Values

Hello Team,   I am trying to create a DAX ranking measure that I can add to a table which ranks the Dealers based of the Volume. The problem i am having here is that "Flow Traders" and "Santanders...
Need Help
Show and Tell
Tutorial Requests
amitchandak's avatar
amitchandak
Super User
2 years ago

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