Forum Discussion
RankX help
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:
I forgot to add what I'm looking for. I'm looking for the ranking on all the totals for each manager for the selected months. Such as Jan & Feb selected;
| Manager 1 | 28 | N/A | 1 |
| Manager 2 | 32 | N/A | 2 |
| Manager 3 | 35 | N/A | 3 |
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:
In your example is [Total count of Reason] a new measure? I'm having trouble replicating your formula, when I try to type in that particular field does not pop up.
![Eample1]("C:\Users\msgeorge\Downloads\Example1.png")
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!!
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!