Forum Discussion
Stop ranking measure dynamically changing when data is sliced
So as many of you will know I have a beautiful ranking measure which ranks average months active by group: Rank: Months Active = RANKX(ALLSELECTED('ELIGIBLE_POLICY'[GROUP POLICY NAME]),CALCULATE(SU...
Hi Anonymous ,
What happens when you modify your DAX as follows:
Rank: Months Active = RANKX(ALL('ELIGIBLE_POLICY'),CALCULATE(SUM('ELIGIBLE_POLICY_HH'[AVERAGE_MONTHS ACTIVE])))
Pragati11
Super User
Super UserHi Anonymous ,
Try chnging your DAX to as follows:
Rank: Months Active = RANKX(ALL('ELIGIBLE_POLICY'[GROUP POLICY NAME]),CALCULATE(SUM('ELIGIBLE_POLICY_HH'[AVERAGE_MONTHS ACTIVE])))
Let me know how this shows the output.
Thanks,
Pragati
Thanks Pragati11 - this works beautifully if I only apply a slicer against the field [GROUP POLICY NAME] but each group has a reference or two associated to it, which people can also use to slice the data.
When I slice by Group reference instead of the GROUP NAME, the ranking goes to 1 still.
Is there any way around this?