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.
Hi all,
I am trying to ignore a page filter in one of my measures by using the formula below.
The filter I want to ignore is the "color name"
But I get the grand total in all rows not the individual value.
Example of what I get:
I need to keep that measure static regardless if the "color filter" changes.
Can someone please help me with this?
Thank you,
Maria
Solved! Go to Solution.
Hi @CP_2024 ,
I created some data:
You can try the following dax:
SUMX(
FILTER('Table','Table'[Type]="Type2"),[Total Case])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @CP_2024 ,
I created some data:
You can try the following dax:
SUMX(
FILTER('Table','Table'[Type]="Type2"),[Total Case])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @CP_2024
Please use the REMOVEFILTER function which page level filter you want to remove.
Ref - https://learn.microsoft.com/en-us/dax/removefilters-function-dax
Please find the one example answer
https://community.fabric.microsoft.com/t5/Desktop/Static-and-dynamic-chart-in-same-visual/m-p/362734...
If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.
Thanks
Pijush
www.MyAccountingTricks.com
https://www.youtube.com/MyAccountingTricks
Hi,
Thank you for your answer but I still get the same result
Yes, using same column for both
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 |
---|---|
95 | |
94 | |
79 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |