Solved: Re: Ranking

Lokisame · ‎02-25-2019

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 · ‎02-25-2019

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-lili6-msft · ‎02-25-2019

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Lokisame · ‎02-26-2019

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.