Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
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.
@mochabits , I doubt you can ignore page level filter.
But still, try like
score_measure = CALCULATE(AVERAGE(Score[Score]), ALL(Employee) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |