Forum Discussion

juncco888's avatar
juncco888
Advocate I
5 years ago
Solved

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:

 

My Expected result is:

 

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
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    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
     

2 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    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
     
    • juncco888's avatar
      juncco888
      Advocate I
      5 years ago

      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