Solved: Use the number of dropdown slicer selections as a ...

Anonymous · ‎10-07-2022

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 · ‎10-07-2022

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎10-07-2022

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here