Forum Discussion

yikcherng's avatar
yikcherng
New Member
2 years ago

Wanted To Fix The Ranking Index Instead Of Changing With Slicer/Filter

Hi Everyone, I'm currently having issue getting a fixed ranking index for my matrix table. 

The dax code that I'm currently using is 

Ranking = RANKX(ALL('Salesperson'[Sales Person]),[Total points Ranking YTD KAM IFmeasure])
however the result is not what I want it to be

 

 

Need Help

1 Reply

  • johnyip's avatar
    johnyip
    Solution Sage
    2 years ago

    yikcherng , 

     

    Please try the following:

    Measure = 
CALCULATE(
RANKX(ALL('Salesperson'[Sales Person]),[Total points Ranking YTD KAM IFmeasure]),
REMOVEFILTERS('Salesperson'[IDM / State])
)

     

    If that does not work, can you provide some sample data here in table / Excel format (not in picture form) for the working?