forecasting scenarios based on initial numbers

Hi b24569314 ,

I create a sample to illustrate how parameter can be used in your problem.

1. Create a New parameter>Numeric range.

Set it like below:

Then a slicer will be automatically created, we can change value in the slicer as we need.

2. Create a measure.

Total Products =
MAX ( 'Table'[Total Products] )
    * POWER (
        [Growth factor],
        MAX ( 'Forcast'[Year] ) - MAX ( 'Table'[Year (current)] )
    )

Get the correct result:

I havn't created the Green Products measure because I'm not quite clear about the logic, the sections in the red line box are separated from the preceding parts by commas and seem to have little to do with each other.

I attach my sample below for your reference.

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.