Forum Discussion
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...
hi, augustindelaf
Try this formula:
Selected PDLs= CONCATENATEX ( VALUES ( Data[Nationality] ) , [Nationality] , ",")
Best Regards,
Lin
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 I also need to display "Multiple Selection" IF the Concatenex values are more than 2.
Than means :
1 selection = [Selection1]
2 selections =[Selection1] ", " [Selection2]
3 sleections and more = "Multiple Selection"
how can I do that, please ?
What I did :
Selected Nationality =
IF(COUNTA( VALUES < 2;
CONCATENATEX ( VALUES ( Data[Nationality] ) ; Data[Nationality] ; ", ")
;"Multiple Selection"
))
But it does not work