topic Re: 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 — Mon, 26 Apr 2021 16:20:29 GMT

(Sorry this is a duplicate question that I posted few days ago, but I did not get answer/solution so I am posting it again).

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?

It appears that the issue is that it only can be used in 'measure', not in 'column' based on the bottom link.

https://community.powerbi.com/t5/Desktop/Dynamic-Calculated-Columns-using-What-If-Parameter/m-p/291884

Then, my next question is how can I convert my formula in measure into 'measure'?

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

amitchandak — Mon, 26 Apr 2021 16:30:53 GMT

JustinDoh1 , the forecast is a measure, just use [forecast] , not need to use max(Parameter[forecast])

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

AlexisOlson — Mon, 26 Apr 2021 16:33:18 GMT

[Forecast] is a measure, not a calculated column, so MAX([Forecast]) doesn't make sense to the calculation engine.

Try this instead:

StarCalculatedParameter1 = VAR Forecast = [Forecast] RETURN CALCULATE ( VALUES ( Star[Value] ), FILTER ( Star, Star[Min] <= Forecast && Star[Max] >= Forecast ) )

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

JustinDoh1 — Mon, 26 Apr 2021 18:38:10 GMT

AlexisOlson

Thank you for quick response and help!

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

JustinDoh1 — Tue, 27 Apr 2021 23:13:03 GMT

AlexisOlson

I have a quick question.

You mentioned that 'Forecast' is a measure.

I have a definition of 'Forecast' as below (as well as screenshot of column in table).

Isn't it a calculated column (just based on what I see)?

Sorry. I am a beginner in DAX.

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

AlexisOlson — Wed, 28 Apr 2021 15:05:02 GMT

Nope. The calculated column icon looks more like the icon next to Parameter (except "fx" instead of "?" in the bottom right corner). The calculator icon is for a measure.