Use "What-if" parameter to set forecast value and then allocate based on actual data

[hidenseek9]

Hello Power BI community!

I would like to use "What-If" parametor to set forecast vol per brand for a month and

allocate the forecast vol to each product based on actual month-to-date (MTD) vol %. 

From here, I would like to generate forecast sales.

Forecast Sales = Est vol by product * MTD actual Sales/Vol

Here are the excel file and Power BI file I created. 

Excel File 

Power BI File 

I have 7 brands (Nike, Adidas, AND1, Converse, Reebok, PUMA, Under Armour)

All the forecast vol are set up using "what-if" parameter. 

There is one tricky part in this. All forecast is done at the brand level EXCEPT for ADIDAS. 

For ADIDAS, the forecast is done at Brand Segment Level. 

I set up a measure to calculate 

Product contribution % to Brand Segment Vol (=Vol CY/Brand Segment Vol) and 

Product contribution % to Brand Vol (=Vol CY/Brand Vol)

From here, how can I set up a measure to calculate forecast vol by product?

and then to calculate forecast sales to have a view like below?

I believe I can do it by manually creating a table with forecast vol.

However it would be nice to be able to do this with "What-if" parameter and see it live. 

Many thanks!

H

[hidenseek9]

@Anonymous 

Hi, is there a way to solve above issue?

Appreciate your support!