Forum Discussion

ViralPatel212's avatar
ViralPatel212
Resolver 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.

Anonymous's avatar
Anonymous
Not applicable
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.

ViralPatel212's avatar
ViralPatel212
Resolver I
2 years ago

Thanks for that. I realised that i had a visual filter and then everything worked!