Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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