User input parameter + automated calculation

[Anonymous]

Hello Community,

I'm new to PBI and I struggle with a combination of a user input parameter and an automated calculation. What I imagine is an automated calculation which can be adjusted by a user input. However, after using the parameter, I have troubles erasing the values so that values show back automated calculation. Is there a way to erase the param and switch back to the automated calculation?

Many thanks for your help

[danextian]

If by user input, you mean what-if parameter, you can write a measure that switches to a different calculation if a user leaves the input value blank but the user must erase the value from the input field. The erasing can be done using bookmarks as well.

[Anonymous]

Hi @danextian 

Thank you so much for reaching back. 

I use this formula: VAR _threshold = IF(ISBLANK(_user_treshold), _automated_threshold, _user_treshold)

How should I modify the formula/bookmarks to make it work?

Let me stress that the problem isn't that the user could not input, but erase an already input value to switch to the automated threshold.

Thank you so much!

[danextian · Accepted solution]

Your measure remains as is but you do need to setup a bookmark affecting just that specific slicer.

[Anonymous]

Works! You're the best @danextian 

[lbendlin]

That doesn't sound like a Power BI thing.  Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?