Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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!
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!
You're amazing! Thank you!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
112 | |
98 | |
98 | |
92 |