I am trying to insert "What If" (New Parameter) calculation value inside Filter's value.
So, here is a scenario.
Based on value of Parameter (what if), for example here (50), "Forecast" value will be added.
So, for the first one 29.33 + (50) = 79.33.
Here is the formula for "Forecast".
Now, I am trying to apply the value of "Forecast" into this Calculate & Filter measure.
Apparently, Measure does not like this field (Parameter[Forecast]).
Is there any way to fix this?
@Anonymous
Are you saying there is syntax issue or my approach (column reference) is wrong?
Should I create a separate column to bring data from calculated field?
Thanks.