What if analysis: reduce the price of one product to see how it affects sales of other products

[Anonymous]

I'm trying to recreate the scenario 1 in this blog post: https://blog.enterprisedna.co/scenario-analysis-techniques-using-multiple-what-if-parameters-advance...

Basically, I want to see what will happen happen to the sales share of other products if the total sales of 1 product or a group of products increases by 5% or by 10%. 

For example:

Before applying 5% increase to total sales of product A and B:

Product	Total Sales	Sales Share
A	21	9.5%
B	40	18.1%
C	50	22.6%
D	32	14.5%
E	78	35.3%
Total	221	100%

After applying 5% increase to total sales of product A and B:

Product	Total Sales	Sales Share
A	22	9.8%
B	42	18.8%
C	50	22.3%
D	32	14.3%
E	78	34.8%
Total	224	100%

[Ahmedx · Accepted solution]

pls try

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

[lbendlin]

ok, what have you tried and where are you stuck?