I have the following pricing table in PBI:
I also have a scenario (parameters) tool that I am using to adjust the “Qty”. I’m trying to calculate a measure “Price per Month” based on the quantity I select with the scenario tool. I only want to return the “per unit cost” in this measure based on the qty. I don’t want to calculate the total cost. So basically with my scenario slider if I select:
Qty < 2 = $2000
Qty 3 -5 = $1500
Qty =>6 = $1250
Hope that is clear.