Ranking

[Lokisame]

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

[v-lili6-msft · Accepted solution]

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]

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.