Forum Discussion
Make Measure ignore filter
Hi , I have a bar chart which has two calculated measure on Y axis and a table column called: "Implementation Date.MONTH" on X axis.
I also have a filter called "Implementation Date.YEAR", I wish one measure (called "Proposal") can ignore the filter.
To summarize: Each item on my table has implementation date and proposal date, but I wish Measure: Implemented can be affected by the filter, Measure: Proposal can Ignore the filter.
I tried to apply ALL() or REMOVEFILTERS() but didn't work.
Should I change the value on Y axis?
Hi MonitorA ,
This is my test table:
The measures I created:
Implemented = CALCULATE(SUM('Table1'[Cost]),'Table1'[Status] = "Implemented") Proposal = CALCULATE(SUM('Table1'[Cost]),'Table1'[Status] <> "Cancelled",ALL('Table1'[Year]))[Proposal] can ignore the filter:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
v-yadongf-msftCommunity Support
Hi MonitorA ,
This is my test table:
The measures I created:
Implemented = CALCULATE(SUM('Table1'[Cost]),'Table1'[Status] = "Implemented") Proposal = CALCULATE(SUM('Table1'[Cost]),'Table1'[Status] <> "Cancelled",ALL('Table1'[Year]))[Proposal] can ignore the filter:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
