If several filters are passed through to drill down page - the "first" element is chosen when using the value in a "Selectedvalue" function within a Textbox value.
Ie - To show what the user has selected within drilldown in a textbox, if several are available - PowerBi resorts to the first value in the list. As opposed to saying "Several".
The value coming from the SelectedValue function is actually blank, using Dax with IF ( ISBLANK ( Measure ), "Several", Measure ) Still returns the first value in the selected value list. Can this be corrected please :).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @macmy034 ,
I don't quite understand your question, but it seems to sound like a limitation of the function itself.I don't quite understand? your question, but it seems to sound like a limitation of the function itself.The value when the context for columnName has been filtered down to one distinct value only. Else, alternateResult.
SELECTEDVALUE function - DAX | Microsoft Learn
Best Regards,
Community Support Team _ Caitlyn