Forum Discussion

augustindelaf's avatar
augustindelaf
Impactful Individual
7 years ago
Solved

display multiple elements with SELECTEDVALUE

Hello,   I am using the DAX measure SELECTEDVALUE to display the value of a column that is filtered in a table visual. But I can't find a way to display multiple elements.   For instance, if "Fr...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, augustindelaf 

    Try this formula: 

    Selected PDLs=
CONCATENATEX ( VALUES ( Data[Nationality] ) , [Nationality] , ",")

    Best Regards,

    Lin

     

  • PattemManohar's avatar
    PattemManohar
    7 years ago

    augustindelaf  Please try this in your measure..

     

    MonthSelection = 
VAR _Count = COUNTROWS(VALUES(_Date[Month]))
VAR _Concat = CONCATENATEX(VALUES(_Date[Month]),[Month],",")
RETURN IF(_Count>2,"Multiple Selection",_Concat)

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

augustindelaf  Please try this in your measure..

 

MonthSelection = 
VAR _Count = COUNTROWS(VALUES(_Date[Month]))
VAR _Concat = CONCATENATEX(VALUES(_Date[Month]),[Month],",")
RETURN IF(_Count>2,"Multiple Selection",_Concat)

augustindelaf's avatar
augustindelaf
Impactful Individual
7 years ago

PattemManohar thanks for the reply !

i think it works but I used another formula :

 

Many thanks anyway
Label - Selected Nationality = 
IF(
     COUNTROWS( VALUES( Data[Nationality] ) ) <3 
    ; CONCATENATEX(VALUES( Data[Nationality] ); Data[Nationality]; ", " )
    ; "Multiple Selection"
)