Forum Discussion

ViralPatel212's avatar
ViralPatel212
Icon for Resolver I rankResolver I
2 years ago
Solved

RanX values changes when Filter is applied

Hi Team.   Hoping you could help. I am trying to create a measure that works dynamically with other filters. As you can see when no filter is selected the ranking works. The ranking is based on th...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • jdbuchanan71's avatar
    jdbuchanan71
    2 years ago

    ViralPatel212 

    Instead of RANKX(ALL try it with ALLSELECTED.

    RANKX(ALLSELECTED('Dealer Ranking'[Counter Party])
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ViralPatel212 

     

    After my tests I came to the conclusion that Function ALL ignores filters applied to tables.

     

    You can remove ALL from the formula.

    IF( [Ranking Size (Vol)] = blank(), BLANK(), RANKX('Dealer Ranking'[Counter Party],[Ranking Size (Vol)],,DESC))

     

    For more information about the ALL function, you can refer to the following documentation: ALL function (DAX) - DAX | Microsoft Learn

     

    Best Regards,
    Community Support Team _Yuliax

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
2 years ago

ViralPatel212 

Instead of RANKX(ALL try it with ALLSELECTED.

RANKX(ALLSELECTED('Dealer Ranking'[Counter Party])
  • ViralPatel212's avatar
    ViralPatel212
    Icon for Resolver I rankResolver I
    2 years ago

    jdbuchanan71 i have tried that but the ranking is not starting from 1 but its starting from 2 and duplicated. See below: