Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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:
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.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
1 |
User | Count |
---|---|
7 | |
6 | |
6 | |
4 | |
3 |