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 g...
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
     
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