Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Dayna
Helper V
Helper V

show the value from a rank on a card

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

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

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! Smiley Happy

 

View solution in original post

2 REPLIES 2
Sean
Community Champion
Community Champion

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! Smiley Happy

 

You're amazing! Thank you!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.