Inserting a value dinamically into a column

[Anonymous]

Hello everyone

I'm novice in PBI and I'm having the following issue:

I have a measure called Difference (whole number) and I'd like to know if it's possible to multiply it by a measure called EnergyConsumption (whole number). The thing is that EnergyConsuption is not a fixed value, it should be possible to change it in a user-friendly way (filtering, MsgBox, Etc).

The result should be a measure or calculated column called Savings with the result of the product Difference*EnergyConsumption.

Thank you for your help.

Antonio I.

[TomMartens · Accepted solution]

Hey @Anonymous 

what you are looking for can be achieved with "What If" parameters, this article describes this in much greater detail: https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Basically, a parameter (the available values) is represented by a table, the user can select one value using a slicer, the selected value can be picked up by using the DAX function SELECTEDVALUE, and used inside a DAX measure.

Hopefully this provides what you are looking for.

Regards,

Tom

[Anonymous]

Hello @TomMartens , you're absolutely right!

This is what I was looking for. Thank you so much.

Antonio I.