Forum Discussion
Advocate VSELECTEDVALUE with Slicer Selection
Unfortunately SELECTEDVALUE does not suppor that. From:
https://msdn.microsoft.com/en-us/library/mt842608.aspx
Term Definition columnName The name of an existing column, using standard DAX syntax. It cannot be an expression. alternateResult (Optional) The value returned when the context for columnName has been filtered down to zero or more than one distinct value. When not provided, the default value is BLANK().
Community ChampionI'm not sure what you mean by Multiple card (multi-row card?). It may have something to do with your data, but I have tested this with text, numeric and date data types in a multirow card. It will return the alternate result if you select multiple items.
Advocate VHi Greg_Deckler Sorry for the confusion,I meant Multi row card visual. Let me put in simple way, I want to display the Multiple(more than one) Selected value from Slicer in Card.
- Greg_Deckler
Unfortunately SELECTEDVALUE does not suppor that. From:
https://msdn.microsoft.com/en-us/library/mt842608.aspx
Term Definition columnName The name of an existing column, using standard DAX syntax. It cannot be an expression. alternateResult (Optional) The value returned when the context for columnName has been filtered down to zero or more than one distinct value. When not provided, the default value is BLANK(). - Miruthan
Hi Greg_Deckler I found the solution ,
Selected = "Selected Product: " & IF(NOT(ISFILTERED(Product[Name])),"All",
CONCATENATEX(ALLSELECTED(Product[Name]),Product[Name],","))
- Greg_Deckler
Nice one!