Forum Discussion
Dynamic Text Box - Make Value Blank When Nothing Is Selected
Hi All, I've got a dynamic text box that updates with whatever selection is made in a slicer. My question is, is it possible to have the Dynamic Text Bo be blank until someone selects something in ...
There is no measure. It just pulls values from a column.
Then how should this work? Use a measure instead.
I'm pulling in text, not numbers. Not sure how one turns text into a measure.
you need to have a measure for this, like:
SELECTEDVALUE(<columnName>[, <alternateResult>])
It returns the value when the context for columnName has been filtered down to one distinct value only. Else, alternateResult.
https://learn.microsoft.com/en-us/dax/selectedvalue-function
Okay....so I would have the alternate result be be the blank, correct?
