Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

What If Parameter Help

  We are trying to use the What-If function for the first time here.  We want to give our CFO/CEO the ability to change the budgeted Margin % to see how the bottom line is impacted.   But, w...
Need Help
TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

you have to provide three What-if parameter, one for each province.

 

Additionally you have to adjust you calculation, checking if one province is selected (in this case it just means used on rows), using this

IF(HASONEVALUE('yourtable'[Province]),
var valueFromWhatIfParameter = 
  SWITCH('yourtable'[Province]
    ,"NB", get the value from that what-if parameter
    ,"NL", ...
    ,0
  )
return
CALCULATE(something using valueFromWhatIfParameter )
)

Hope this gives you an idea how to tackle your requirement.

 

Regards

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi TomMartens,

 

First of all, thank you for helping me.

 

I tried this

Budget%Margin = IF(HASONEVALUE(CRM_Dim_Projects[Province]),
var valueFromWhatIfParameter = 
  SWITCH(VALUES(CRM_Dim_Projects[Province])
    ,"NB", NB[NB Value]
    ,"NS", 'CM%'[CM% Value]
    ,0
  )
return
CALCULATE(AVERAGE(CRM_Fact_SalesOpportunities[Budget%Margin])+valueFromWhatIfParameter )
)

But it doesn't work. Could you have a look at my codes and tell me what is wrong please?

  • TomMartens's avatar
    TomMartens
    Super User
    9 years ago

    Hey,

     

    currently I have no idea, but please have a look at the solution from Vvelarde it uses a similar approach, maybe you can adapt to his approach.

     

    Regards

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous,

    >>Thus far we have only been able to impact the entire Budget % Margin column, rather than focusing in on one margin adjustment.

    Could you please explain this requirement in details? And share your sample table to test if I have any idea?

    Best Regards,
    Angelia