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
juncco888
Advocate I
Advocate I

Ranking Assistance with RANKX

Hi again,

I am trying to use RANKX to get the Sections with the most number of Cases.

Here is some sample data:

 

forum1.JPGMy Expected result is:

forum2.JPG

 

I have tried several things but can't get the cases counted by section and then use rankx to rank the number of cases by section.  I am trying to do this as a measure and not create a column of the number of cases per section.
 
Any help would be greatly appreciated.
 
Thanks
Kyle
1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @juncco888 ,

 

if you don't put the "Case Number" in your table (like in your last example), the following measure should work:

Rank = RANKX( ALL( myTable[Section] ), CALCULATE( COUNTROWS( myTable ) ) )

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

2 REPLIES 2
selimovd
Super User
Super User

Hey @juncco888 ,

 

if you don't put the "Case Number" in your table (like in your last example), the following measure should work:

Rank = RANKX( ALL( myTable[Section] ), CALCULATE( COUNTROWS( myTable ) ) )

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

Thank you so much!  That worked perfectly.  I added the order and tiebreaking arguments just to see how they worked out.  

 

I really appreciate your help!

 

Kyle

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.