Calculated Column based on Condition.

Hello - this sounds like something you could use a what-if parameter for: 

What if Analysis in Power BI (Multi-layered Scenar... - Microsoft Fabric Community

Getting Started With The "What If" Parameter In Power BI | Enterprise DNA

'What If' Analysis Techniques For Power BI - Microsoft Fabric Community

Hi Anonymous ,

As audreygerred  said, we can create a numeric range of parameter.

Since the calculated columns do not have access to the parameter values, we need to create a measure.

Proposed ARR = MAX('Table'[ARR]) * (1+SELECTEDVALUE(Parameter[Parameter]))

Then the result is as follows.

Best Regards,

Neeko Tang

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