Created measures with variables updated on the fly

[Anonymous]

Hello,

I have a general question and was wondering if what I am thinking about is possible:

This hypothetical situation is a much simpler version of what I'm trying to do...but if what I am about to lay out is possible...then in theory the larger version of this is also possbile.

In the perfect world I would have a created measure that would read something like this:

Created Measure = Sum ( 'ClaimData' [PlanPaidAmount] ) * [ User entered Data Value ]

I want to have the ability to have some kind of visual where the user could type in a data value and have the [ User entered Data Value ] portion of the created measure populate so that the measure itself would update.

I'd want this to be user friendly in the sense that I will have this published to a sharepoint site and don't want the user to have to go in to transfor data to update the value.

Is this clear enough?  I can explain in more detail if needed.

[Anonymous]

Hi @Anonymous ,

Check what-if parameter.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if 

Best Regards,

Jay

[littlemojopuppy · Accepted solution]

Hi @Anonymous unfortunately the closest thing that allows for user input would be a what if parameter.  Although if you have a somewhat small set of possible values that might be a reasonable solution for you...