Forum Discussion

puneethjp's avatar
puneethjp
Icon for Helper II rankHelper II
2 years ago
Solved

Removefilters not working as expected.

Hi,    I have list of filters as below.    Requirement:  Incr. $ share `=Sum(incr. $)/SUM(mega category $)*100  Numerator= sum(incr $ for any selected in filters) Denominater : disre...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi puneethjp ,

     

    Consider using other DAX functions: If the "REMOVEFILTERS" function is not giving you the desired results, you can try using other DAX functions like "ALL", "ALLEXCEPT", or "CALCULATETABLE" to manipulate the filter context and achieve the desired outcome.

     

    Best Regards,

    Stephen Tao

     

    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 puneethjp ,

 

Consider using other DAX functions: If the "REMOVEFILTERS" function is not giving you the desired results, you can try using other DAX functions like "ALL", "ALLEXCEPT", or "CALCULATETABLE" to manipulate the filter context and achieve the desired outcome.

 

Best Regards,

Stephen Tao

 

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

puneethjp's avatar
puneethjp
Icon for Helper II rankHelper II
2 years ago

Hi Anonymous 

 

KeepFilters , All Except  worked. 

 

Thank you.