Forum Discussion

annjoseph's avatar
annjoseph
Regular Visitor
6 years ago
Solved

What if parameter

I have sales table with Product Group name,Product Sub group name,Volume, Price. I created a Matrix with Product Group name and Product Sub group in rows and volume and price in Values.Then i have c...
Need Help
Show and Tell
Tips and Tricks
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi annjoseph ,

     

    If the ratio of changes between products is fixed, then amitchandak solution is indeed effective.

    Otherwise you may need to create multiple ‘What if’ parameters.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi annjoseph ,

     

    Measure = 
SWITCH(
    SELECTEDVALUE(Sales[CountryRegion]),
    "China", SUM(Sales[Sale 2013]) * [Parameter1 Value],
    "Germany", SUM(Sales[Sale 2013])*[Parameter2 Value],
    "United", SUM(Sales[Sale 2013])*[Parameter3 Value]
)

    You need to create multiple 'What-IF' parameters, otherwise, you need use bookmark feature.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
6 years ago

annjoseph , you can have more than one whatif or /with a measure like this

 

new measure =
switch ( true(),
FIRSTNONBLANK(Table[Product],"NA") ="book" , [Measure] * selectedvalue(param[param]),
FIRSTNONBLANK(Table[Product],"NA") ="table " ,[Measure] *selectedvalue(param[param]) *2 ,
/// Add more conditions
[Measure]
)

 

new measure =
switch ( true(),
FIRSTNONBLANK(Table[Product],"NA") ="book" , [Measure] * selectedvalue(param1[param1]),
FIRSTNONBLANK(Table[Product],"NA") ="table " ,[Measure] *selectedvalue(param2[param2]) ,
/// Add more conditions
[Measure]
)