RankX Ranking same values as same rank

[Anonymous]

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(ALL(System_Users),Audit[SUM Pro Audit])

[amitchandak]

@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