Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
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.