Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

RankX help

I've tried a number of solutions reading through these forums and have learned quite a bit. But I'm still struggling with this particular Ranking. Here is a sample of what my data looks like.   ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    How about this:

    RANKX = 
IF ( 
    HASONEVALUE( 'RankX Help'[sup_nam]),
    RANKX( 
        ALL('RankX Help'[sup_nam]), 
        [Total Count of Reason],,ASC,Dense
    )
)

    Looks like it produces what you are after:

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Nevermind on my last post. Got it created new measure summing Count of reason. Was having troubl of rank showing all 2's but swapped count of reason out for for my new measure and it perfectly. 

 

Thank you so much Nick!!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yes, sorry about that, it was a new measure. If you do not use a measure there you need to be sure to use CALCULATE in the expression in order to invoke context transition. If not you will get the same values! I like to use measures since 1) I may be able to use them else where, 2) If i have to make a change, just have to make it once and 3) using a measure has an implied calculate wrapped around it, so don't need to work.  

 

Glad it helped!

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    The tip regarding measures is great. I like all the points you listed. I will definitley have to start using them more.

     

    Thanks again!