Forum Discussion
RankX Ranking same values as same rank
Good Day, I am getting duplicate rankings when they have the same value. In this case its zeros. Is there a way to get it to represent 1,2 and 3 instead of 1,1,1? Pro Audit Rank = RANKX(A...
Anonymous , Power bi measure rank is dependent on what you have used in visual to if created rank on table System_Users column coming from any other table will redistribute the rank
RANKX(ALL(System_Users),Audit[SUM Pro Audit])
RANKX(ALL(System_Users[Full Name], System_Users[MVR Branch],System_Users[Entity Name]),Audit[SUM Pro Audit])
refer
Power BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA