topic How to insert calculated value as Filter (Calculate/Filter) value in DAX Commands and Tips

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

JustinDoh1 — Fri, 23 Apr 2021 17:47:33 GMT

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 — Fri, 23 Apr 2021 20:12:25 GMT

JustinDoh1 — Fri, 23 Apr 2021 20:32:53 GMT

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.