cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JustinDoh1
Continued Contributor
Continued Contributor

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

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.

Table1.png

Here is the formula for "Forecast".

Param0.png

 

Now, I am trying to apply the value of "Forecast" into this Calculate & Filter measure.

Param1.png

 

Apparently, Measure does not like this field (Parameter[Forecast]).

Is there any way to fix this?

2 REPLIES 2
JustinDoh1
Continued Contributor
Continued Contributor

@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.

Anonymous
Not applicable

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.