Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
Can someone help me how to display the ranking of data based on the count?
And what if there are ties, how to display their ranking? I've already tried the RANKX function but it only displayed Rank 1 on all the data.
Thank you in advance. 🙂
Hi @da26
Try the following
1. Create a measure called sumCount = sum( yourtable[CountofHN] )
2. Create a measure called
Rank =
IF (
HASONEVALUE ( yourtable[Diagnosis] ),
RANKX ( ALL ( yourtable[Diagnosis] ,yourtable[CountofHN]),[sumCount],,desc,dense)
)
If this works please accept this as a solution and also give KUDOS.
Cheers
CheenuSing
Post your Measure formula
Rank = IF ( HASONEVALUE ( IPD_CurrentOpenStatus[Diagnosis] ), RANKX ( ALL ( IPD_CurrentOpenStatus[Diagnosis] ), CALCULATE ( COUNTA ( IPD_CurrentOpenStatus[HN] ) ),, ASC, DENSE ) )
@da26 How about now?
How is you data organized - post some sample of what the table looks like?
Hi @Sean
I already found the solution in ranking. 🙂
But what I am trying to know now is there any way to remove the ties in ranking? As you see here, when there is a tie, the ranking was just like this.
Thank you again. 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |