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?
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?
Rules for DAX Code Formatting - SQLBI
Click here to read more about the November 2022 updates!
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.