cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mochabits
Helper II
Helper II

DAX measure to ignore page filters

The PBIX file is here: https://drive.google.com/file/d/14OfA6BXKvqijBZbSw_OoU9Os0s9o7Yur/view?usp=sharing 

 

Two tables in the report: Score and Employee. Both are linked with "employee key". The page has two page level filters on employee's "position title" and "Employee Status Reason Desc".

 

I want the DAX - "score_measure" to ignore the page filters to produce the result like the table at the bottom. I've tried ALL and FILTER ALL on either or both tables, but can't get the correct result. Please help and thanks for your time.

score_measure = CALCULATE(AVERAGE(Score[Score]), ALL(Employee[Position Title], Employee[Employee Status Reason Desc]) )

 

Full Name

Score

A1

0.84

A2

0.92

A3

0.62

A4

0.86

A5

0.81

 

2 REPLIES 2
Anonymous
Not applicable

@mochabits 

 

No, there is NO WAY to ignore page level filters through DAX. Sorry. You're a bit out of luck here. What you can do is create visual level filters where you need to and not use a page level filter at all on the page in question. Page level filters affect all visuals on the page and there is absolutely no way DAX can reach beyond such a filter.

amitchandak
Super User
Super User

@mochabits , I doubt you can ignore page level filter.

 

But still, try like

 

score_measure = CALCULATE(AVERAGE(Score[Score]), ALL(Employee) )

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!