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 Selected Values?


Thanks in Advance,
Sowmiya.

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

2 Replies

  • 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