Forum Discussion

Marcus_swe's avatar
Marcus_swe
Frequent Visitor
7 years ago
Solved

RANKX - inconsistent ranking

Hi, I am new to the PowerBi world, mostly fun but i have been stuck on this issue for some time now. I can't figure out why i can't get the RANKX function to work. I want to summarize all the sales...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Marcus_swe 

    You may use below measure:

    Ranking by sales =
RANKX (
    ALL ( Table1[Sales Person ID] ),
    CALCULATE ( SUM ( Table1[Sales] ) ),
    ,
    DESC,
    DENSE
)

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Marcus_swe 

You may use below measure:

Ranking by sales =
RANKX (
    ALL ( Table1[Sales Person ID] ),
    CALCULATE ( SUM ( Table1[Sales] ) ),
    ,
    DESC,
    DENSE
)

Regards,