Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
(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.
Then, my next question is how can I convert my formula in measure into 'measure'?
Solved! Go to Solution.
[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 )
)
[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 )
)
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.
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.
@JustinDoh1 , the forecast is a measure, just use [forecast] , not need to use max(Parameter[forecast])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |