Prevent column filter in Matrix

[Daxinitup]

I think I have a simple problem to fix. I need the Yealry Budget column to remain "fixed" in a matrix table regardless of the slicer value selected (month) I need to show monthly spending and budget as well as the yearly overall budget. 

 

[Shaurya]

Hi @Daxinitup,

Create a measure to calculate yearly budget that exludes filters context:

Yearly Budget Column = CALCULATE([Yearly Budget],ALL('Table Name'))

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Previous Forecasts

[Daxinitup]

This brought the total amount of entire column and placed that value in each row. Is there a way to just isolate what the budget would be cumulative at the last day of the year? 

[v-zhangti]

Hi, @Daxinitup 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.