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 measure with manager current place in competition. Manager after choosing their name on slicer should see their resoult (points), components but primaly his position in contest. 

Please help

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

     

     

2 Replies

  • 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.