Dynamic filtering in measure with a variable

Hi, tjalleph 

According to your description, I can roughly understand your requirement, then I created a data model to make a test based on your sample data, you can try my steps:

1. Create a calculated table for the slicer, which is the same as the calendar table:

Slicer = 'Calendar'

Then keep the table don’t have any relationship with others:

2. Create three measures in the table:

Budget =

var _minmonth=MINX(ALLSELECTED(Slicer),[Month number])

var _maxmonth=MAXX(ALLSELECTED(Slicer),[Month number])

return

IF(MAX('Calendar'[Month number])>=_minmonth&&MAX('Calendar'[Month number])<=_maxmonth+3,SUM(Budget[Budget]),BLANK())

Forecast =

var _minmonth=MINX(ALLSELECTED(Slicer),[Month number])

var _maxmonth=MAXX(ALLSELECTED(Slicer),[Month number])

return

IF(MAX('Calendar'[Month number])>=_minmonth&&MAX('Calendar'[Month number])<=_maxmonth+3,SUM(Forecast[Forecast]),BLANK())

Actuals =

IF(MAX('Calendar'[Month]) in SELECTCOLUMNS('Slicer',"1",[Month]),SUM(Actuals[Actuals]),BLANK())

Then create a slicer and a table chart to place them like this:

And you can get what you want.

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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