cancel
Showing results for
Did you mean:
Frequent Visitor

## Contest

Hello,

we create contest in our company and i want to show resoults.

Our managers and their offices are collect points. One manager have many offices. For example:

Manager1 - 50 points (their offices: Office1 - 30 points, Ofiice2 - 10points)
Manager 2 - 70 points (Office3 - 20 points, Office4 - 5ponts)

Soo the rank look line this:
1. Manager2
2. Manager1

1. Office1
2. Office3
3. Office2
4. Offce4

And this was easy part - I used "Ranking = RANKX(ALL(Table1),CALCULATE(SUM(Table1[Score])),,DESC)" all works good.

But i need to show this on chart and when i drill down Manager to see their offices I need to keep this resoults. For exaple:
When i drill manager2 i see Place 1- Office 3, Place 2 - Office4  - It should be Office3 - place2 and Office4 - place4.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team

## Re: Contest

Hi @Lokisame ,

One sample for your reference. We can create two measures to get the excepted result.

`scorem = CALCULATE(SUM(Table1[Score]))`
`Measure = IF(ISINSCOPE(Table1[Office]),RANKX(ALL(Table1),[scorem],,DESC),RANKX(ALL(Table1[Manager]),[scorem],,DESC))`

Please find the pbix as attached.

Regards,

Frank

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

## Re: Contest

Hi @Lokisame ,

One sample for your reference. We can create two measures to get the excepted result.

`scorem = CALCULATE(SUM(Table1[Score]))`
`Measure = IF(ISINSCOPE(Table1[Office]),RANKX(ALL(Table1),[scorem],,DESC),RANKX(ALL(Table1[Manager]),[scorem],,DESC))`

Please find the pbix as attached.

Regards,

Frank

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

## Re: Contest

Hi @Lokisame ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

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