Forum Discussion
JustinDoh1
Post Prodigy
Post ProdigyHow to insert calculated value as Filter (Calculate/Filter) value
(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 ...
[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 ) )
AlexisOlson
Super User
Super User[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 )
)- JustinDoh1
Thank you for quick response and help!
- JustinDoh1
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.
- AlexisOlson
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.
