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)

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, augustindelaf 

Try this formula: 

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

Best Regards,

Lin

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

This is what I needed...thank you so much!!