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

annjoseph's avatar
annjoseph
Regular Visitor
5 years ago

Thanks for the reply. Hard coding measures wont work for our requirement.

As per our requirement, we need to find the What-If Solution for each product based on what-if parameter. I will be having one what-if parameter & when i select one product i should be able to apply the what-if condition to that product . Then, that product's value should be changed to what-if condition. Similarly I should be able to apply different what-if condition for each products based on my selection. Final results will be a table of all products selected with changed values and un-selected products with unchanged values. The whole process should be dynamic.

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 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.