Forum Discussion

fergalom's avatar
fergalom
Frequent Visitor
8 years ago

WhatIf Parameter & Measures

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

 

 

Need Help

2 Replies

  • jthomson's avatar
    jthomson
    Solution Sage
    8 years ago

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

    • fergalom's avatar
      fergalom
      Frequent Visitor
      8 years ago

      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?