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,

Marcus_swe's avatar
Marcus_swe
Frequent Visitor
7 years ago

Anonymous Thank you for the links, they gave me alot better understanding! 

 

v-cherch-msft Worked like a charm, together with the other information i have recoved i should be able to sort things out now! 

 

mussaenda Cant understand why i didnt find that youtube clip by my selfe, it was more or less exactly what i was looking for! 

 

I am verry greatful for your help!!

 

BR Marcus