Forum Discussion

Lokisame's avatar
Lokisame
Helper I
7 years ago
Solved

Ranking

Hello,  In my company we create contest for our managers. I need to displey resoults. I allready created measure whitch counts managers score and the score components. Now I need to create me...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Lokisame 

    You could use RANKX Function to create your expected measure as below:

     

    Ranking = RANKX(ALLSELECTED(Table1),CALCULATE(SUM(Table1[Score])),,DESC)

    Result:

    Best Regards,

    Lin

     

     

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Lokisame 

You could use RANKX Function to create your expected measure as below:

 

Ranking = RANKX(ALLSELECTED(Table1),CALCULATE(SUM(Table1[Score])),,DESC)

Result:

Best Regards,

Lin

 

 

  • Lokisame's avatar
    Lokisame
    Helper I
    7 years ago

    Thank you :) You help me a lot. 

     

    Maybe you know how add to this query a filter? Not all of managers are taking part in this competition. For example i have table with managers with their ID and status - I need to create ranking only for managers with status 1 and eliminate status 2,3...

    Additionaly is it posoble to add the resoult of Rankx to manager name? - For exaple (1) Manager7, (2) Maneger3 - I need to use it on chart axis.