what-if parameters for product allocation

[Anonymous]

Hi

I Have two data set, product unit price and allocation, also the product demand. I would like to create a what if simulation that I allocation part A123 in supplier At o 80%, how the spend would change? and It will automatically change supplier B allocation to 20%. Is there any way I can do?

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

Hope I didnt misundertand your point.

First create a what-if parameter and set the default value as 0.8;

Then create 2 measures as below:

Measure for A = CALCULATE(MAX('Table (2)'[Demand]),'Table (2)'[Parts]="A123")*'Parameter 1'[Parameter 1 Value]

Measure for B = CALCULATE(MAX('Table (2)'[Demand]),'Table (2)'[Parts]="A123")*(1-'Parameter 1'[Parameter 1 Value])

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!