using multiple parameters in calculation

[briodan]

I have a requirement I'm not sure how to implement.

We have a table of devices we need to upgrade to a new software version. however, each location will be able to upgrade a different number of devices in one week. I need to be able to run what-if scenarios where I increase/decrease the number of upgrades in a city but keep the others constant to get estimates on how long it will take to upgrade each location.

this is a simplification of my data:

location	device serial number
NY	123
LA	124
NY	134
LA	345
HOU	367

using the serial number to get a count of devices in each location

my thought is that I would create a parameter for each location and then use those parameters in a calculation,

Each parameter would have a value from 1 to 5 for example in 1 increments.

But I'm not sure how to properly filter the results for to get a table result like the following

Location	Devices	Devices/Week	Weeks
NY	100	5	20
LA	210	4	53
HOU	150	3	50

where via a slicer i can change the number of devices per week in NY alone.

in pseudo code I imagine this to look something like this:

if location = NY then divide Devices by "NY Devices/Week parameter"

elseif location = LA then divide Devices by "LA Devices/Week parameter"

else divide Devices by "HOU Devices/Week parameter"

but not sure how to translate that into DAX.

[Anonymous · Accepted solution]

@briodan,

Please check if what-if parameter and DAX in the attached PBIX file returns your expected result. If not, please describe more details about the week parameter and how you get the second table based on the first table.

Regards,
Lydia