Forum Discussion

david_ha's avatar
david_ha
New Member
1 year ago

issue with a simple DAX function using REMOVEFILTERS

Hi everyone,

I’m experiencing an issue with a simple DAX function using REMOVEFILTERS, which behaves as expected when tested in a DAX query view (e.g., with summarizecolumns) but fails to clear filters when used in a table or matrix visual in Power BI Report Server Desktop (September 2024 release).

Here are the details:

  • I have a very basic measure that uses REMOVEFILTERS to clear specific filters on a column.
  • While this works perfectly in the DAX query editor, the visual context (table/matrix) still applies the filters, ignoring REMOVEFILTERS.
  • I also tried alternative functions like ALL and ALLSELECTED, but they do not work in the visual either.
DAX
Power

2 Replies

  • divyed's avatar
    divyed
    Super User
    1 year ago

    Hello david_ha ,

     

    Can you share your DAX to check further ?

    Here are some steps you can take to trobleshoot :

    1. Use REMOVEFILTERS or ALL with specific column or table references to ensure you're targeting the correct filters. 

    2. Use intermediate variables to check how filters are being applied

    3. Check relationships if setup correctly.

     

    I hope I answered the question. Mark this as solution if this helps, Kudos are appreciated.

     

    Linkedin : https://www.linkedin.com/in/neeraj-kumar-62246b26/

    Cheers

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, david_ha 

    I am glad to help you.

     

    Can you please share your DAX for checking?


    Have you tried the method provided by divyed for checking and is the method provided by divyed applicable in your case now?


    If REMOVEFILTERS still doesn't solve the problem, you can try using the ALLEXCEPT function which clears all filters except the specified columns.

     

    You can also check if this post is helpful:

    Solved: REMOVEFILTERS Function Not Working and Filter stil... - Microsoft Fabric Community

     

     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.