show the value from a rank on a card

[Dayna]

Hi all!

I want to show on a card the top rank value. I have got a measure which calculates rank:

ChangeManagerRank = 
RANKX ( ALLSELECTED ( sduser_cm[FullName] ), CALCULATE ( DISTINCTCOUNT(changedetails[changeid] ) ) )

And I want to show the person on the card who is rank one. How do I do this, please? If I add my measure to the card, I only get a number. 

Many thanks,

Dayna

[Sean · Accepted solution]

Hi @Dayna,

Here are 3 options to obtain the person's name.

Top Person V1 =
CALCULATE (
    FIRSTNONBLANK ( sduser_cm[FullName], 1 ),
    FILTER ( ALL ( sduser_cm[FullName] ), [ChangeManagerRank] = 1 )
)

Top Person V2 =
FIRSTNONBLANK (
    TOPN (
        1,
        VALUES ( sduser_cm[FullName] ),
        CALCULATE ( DISTINCTCOUNT ( changedetails[changeid] ) )
    ),
    1
)

Top Person V3 =
CONCATENATEX (
    FILTER ( VALUES ( sduser_cm[FullName] ), [ChangeManagerRank] = 1 ),
    sduser_cm[FullName],
    ", ",
    sduser_cm[FullName], ASC
)

The last Measure Top Person Version 3 will give you all names in case sevaral people are tied for 1st place.

Hope this helps!

[Dayna]

You're amazing! Thank you!