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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
molegris
Advocate IV
Advocate IV

Super filter not affected by DAX context modifiers

Hi,

 

Is there a way to create filters that superseed any context modifier in DAX formulas? 

 

Use case :

I'm creating a report from a dataset that I cannot modify.  So I don't have access to M query nor any calculated column.

I would like to ignore a portion of the dataset that is irrelevant for the whole report I'm creating.  So I can use DAX functions like CALCULATE(), ALL(), etc.  without being bothered by those extra rows from irrelevant data.  I tried to put the filter in the "Apply to all pages" section but it doesn't have the desired effect.

 

Thank you

 

--mo

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @molegris ,

 

unfortunately this is not possible.

Using ALL(...) or similar filter-modifying functions inside a CALCULATE will also affect page level filters.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @molegris ,

 

Unfortunately, I think this is impossible. This influence between the DAX function and the page filter still exists.

 

Best Regards,

Yuna

TomMartens
Super User
Super User

Hey @molegris ,

 

unfortunately this is not possible.

Using ALL(...) or similar filter-modifying functions inside a CALCULATE will also affect page level filters.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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