Forum Discussion

MonitorA's avatar
MonitorA
Regular Visitor
3 years ago
Solved

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 on...
Need Help
Tips and Tricks
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    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.

v-yadongf-msft's avatar
v-yadongf-msft
Icon for Community Support rankCommunity Support
3 years ago

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.