Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Post Patron
Post Patron

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

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!


Post Patron
Post Patron



Hi, is there a way to solve above issue?


Appreciate your support!


Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors