WhatIf Parameter & Measures

[fergalom]

Using a what if parameter to see the effect additional budget would have on a project.

BUDGET+Additonal = 'WhatIf BUDGET'[WhatIf BUDGET Value]+sum('sage_project'[TOTAL_BUDGET])

Also have a Line/Stacked Column chart which displays month by month costs as bars and cumulative costs and budget as lines

Cumulative measure for BUDGET+Additonal is:

BUDGET+Additonal total for Date =

CALCULATE([BUDGET+Additonal], FILTER(ALLSELECTED('DateTable'[Date]),ISONORAFTER('DateTable'[Date], MAX('DateTable'[Date]), DESC)))

My issue is this measure ignores the date filter on the page and displays a line across 10 years rather than relevant years.

How can I adjust the measure to ignore the Whatif BUDGET Value oustside the filtered dates?

First pic below is the problem, last is how it should look normally

[jthomson]

Could you not add a visual level filter for the last twelve months?

[fergalom]

Already using a Timeline date filter visual (as some projects 3 years, some 6 months etc) on the report, only 'WhatIf BUDGET'[WhatIf BUDGET Value] ignores this filter unlike the other values.

Perhaps because the Whatif BUDGET has no relationship to the date table?