Dynamic filters on calculated measures?

[mstotland]

I have a large data table with columns for Scenario (Budget, Forecast, Actual), and Year (2015-2024).

I have the following measure:

Scenario 1 = CALCULATE(SUM('values'[Report Value]), 'Account Map'[Exclude From Fin?] = "0")

I know I can input Year and Scenario as filters in the SUM, but I want this filter to be dynamic and based on user selection (to be able to easily and quickly switch between years and scenarios). I can use a slicer to achieve this, but in my matrix visual, I'm using 3 calculated measures (Scenario 1, Scenario 2, Variance), and I need to be able to independently filter each Scenario measure (e.g. 2024 Budget vs. 2023 Forecast). I tried to play with multiple slicers, but doesn't seem to be a way for a slicer to be limited to a specific measure rather than the whole visual. 

Thanks in advance!

[ERD · Accepted solution]

Hi @mstotland , you need a second table with Years. Is this case you might use your Date table for the first scenario and Years table for the second scenario measure.