Forum Discussion

JustinDoh1's avatar
JustinDoh1
Post Prodigy
5 years ago

How to insert calculated value as Filter (Calculate/Filter) value

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?