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

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!