Forum Discussion

Anonymous

Not applicable

4 years ago

Measure for top rank category

Hello, I want to add some text in my dashboard such as "XXX had the highest score" where XXX updates depending on how the dashboard is filtered. I have played around with ranking/if stateme...

Icon for Community Champion rank

Community Champion

4 years ago

Do you already have the measure for the rank? If so, you can use:

Rank 1 Category = 
CALCULATE(MAX(Table[Category]), FILTER(VALUES(Table[Category]), [Rank] = 1))

Anonymous

Not applicable

4 years ago

Hi,

Yes I do - I have some -0's in my data so used the following measure to account for minus numbers...

RANK=IF(

NOT(ISBLANK([change yoy])),

RANKX(

FILTER(ALLSELECTED(Combined[Question]), NOT( ISBLANK([change yoy]))),

[change yoy]

)

)

Thanks"

PaulDBrown
Community Champion
4 years ago
Try the measure I posted above. Beware that this will only return the max value if there are more than one categories ranked as 1. To avoid this, you can try

Rank 1 Category = CONCATENATEX ( FILTER ( VALUES ( Table[Category] ), [Rank] = 1 ), Table[Category], ", " )
- Anonymous
  Not applicable
  4 years ago
  Thank you - will give this a go and let you know how I get on.