Forum Discussion

Sowmiya's avatar
Sowmiya
Helper III
7 years ago
Solved

DAX

 Hi Community,   =SELECTEDVALUE(Table[A]) will return the "Single Selected" Value selected in the Filter Visual. When Multiple Value is Selected in Filter, What is the DAX to display Multiple Selec...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Sowmiya Is this what you are looking for ? Try this as a Measure..

     

    Test110New = 
VAR _Concat = CALCULATE(CONCATENATEX(VALUES(Test110CrossSelection[Product]),Test110CrossSelection[Product],","))
VAR _IsFiltered = IF(ISFILTERED(Test110CrossSelection[Product]),_Concat,"No Selection")
RETURN _IsFiltered

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

Sowmiya Is this what you are looking for ? Try this as a Measure..

 

Test110New = 
VAR _Concat = CALCULATE(CONCATENATEX(VALUES(Test110CrossSelection[Product]),Test110CrossSelection[Product],","))
VAR _IsFiltered = IF(ISFILTERED(Test110CrossSelection[Product]),_Concat,"No Selection")
RETURN _IsFiltered

Sowmiya's avatar
Sowmiya
Helper III
7 years ago

Yes, this is what actually I was looking for. Measure Works fine.
Thanks PattemManohar