Hi, sorry for very easy thing for you but I have a question.
In order to create some graph, I would like to make an expression of "sum ignoring filter".
For example, in the case as below, even if I check some filter, I would keep "Sum value".
It would be appreciated if you could help me. Thanks!!
I can see you are ignoring all the dates, you want to ignore the column that you are using on the slicer ?
If yes, it's something like:
CALCULATE(SUM(TABLE[COLUMN]), ALL(TABLE[COLUMN_USED_ON_SLICER]))
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Hi @yugofukuda ,
You can create a measure like:
CALCULATE(SUM(TABLE[VALUE]), ALL(TABLE[COLUMN_FILTER]))
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Thank you for your quick response.
Actually, i tried to use that but it didn't go well as below. How should I do??
I can see you are ignoring all the dates, you want to ignore the column that you are using on the slicer ?
If yes, it's something like:
CALCULATE(SUM(TABLE[COLUMN]), ALL(TABLE[COLUMN_USED_ON_SLICER]))
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Monthly Update - February 2026
Check out the February 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
