Dynamic Price Slider

[benP]

Hi all, 

I'm working on an energy report which shows consumption in kWh. I currently have this translated into £ using a hardcoded measure 

Cost = 0.148 * 'Energy Data'[Sum of Consumption]

This gives me a monetry value of 14.8 pence per kilowatt hour. I need to make this price dynamically adjustable via a slider ranging from 0 - 0.50p so the cost will update based on the slider input. Does anyone have any experience with something similar to this? 

Any advice would be greatly appreciated. 

Thanks, 

Ben 

[Anonymous · Accepted solution]

Hi @benP ,

Hope you have a  SlicerTable with different prices as values which is used as a slicer.

Let us assume the column name is Rate

Try the formula

Check = CALCULATE('Energy Data'[Sum of Consumption] * SELECTEDVALUE(SlicerTable[Rate]))

We take the value of SlicerTable[Rate] that is selected and use that to multiply 'Energy Data'[Sum of Consumption].

Cheers

CheenuSing

[benP]

This worked perfectly. 

Thank you sir