Forum Discussion
User input parameter + automated calculation
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...
Your measure remains as is but you do need to setup a bookmark affecting just that specific slicer.
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.
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!