Use the number of dropdown slicer selections as a variable in simple Divide calc column?

[Anonymous]

In the screenshot below I want to use the Numer of Sprints in the dropdown to pass as a variable in a simple divide(sum) statement.. is this possible? I'm using a hard-coded 3 now as you see.

Sprint Velocity2 =

        DIVIDE(SUM('Sprint Burndown'[Sprint Done Points]), 3 )

[amitchandak · Accepted solution]

@Anonymous , use a what if parameter

Sprint Velocity2 =
DIVIDE(SUM('Sprint Burndown'[Sprint Done Points]), [What if meausre] )

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if