Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
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?
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.