Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

 

 

 

 

 

Duplicate Values
ranking
RANKX

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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