Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
david_ha
New Member

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.
2 REPLIES 2
Anonymous
Not applicable

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.

divyed
Super User
Super User

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

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.