Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear BI users,
Hope you to share creative ideas about below issue.
Objectives
Problems
Question
Alternative
Sincerely,
Lee, Hong Gwoo
Solved! Go to Solution.
Hi @extri13,
As your post, ALL() function ignores all slicers and Visual/Page/Report filters. In order to apply only Page Level Filter not by a slicer on the page, you would need to use ALLSELECTED() function instead of ALL() function, and utilize "Edit Interaction” feature(Alternative #2). ALLSELECTED is removing only filters created by the rows/columns in the current query, but retains explicit filters. For more details about difference between ALL() and ALLSELECTED(), please review this similar blog.
In addition, comparing to Alternative #1, Alternative #2 is more practical and more convenient. For more details, please review the example in the attached PBIX file.
Thanks,
Lydia Zhang
Hi @extri13,
As your post, ALL() function ignores all slicers and Visual/Page/Report filters. In order to apply only Page Level Filter not by a slicer on the page, you would need to use ALLSELECTED() function instead of ALL() function, and utilize "Edit Interaction” feature(Alternative #2). ALLSELECTED is removing only filters created by the rows/columns in the current query, but retains explicit filters. For more details about difference between ALL() and ALLSELECTED(), please review this similar blog.
In addition, comparing to Alternative #1, Alternative #2 is more practical and more convenient. For more details, please review the example in the attached PBIX file.
Thanks,
Lydia Zhang
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |