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)
Hello Augustin,
I think CONCATENATEX is going to do what you want. CONCATENATEX iterates over a table and concatenates a text expression evaluated for each row of the table. In particular, you can use CONCATENATEX with VALUES to concatenate distinct values from a column.
You could write a measure like this to create a comma-separated string of Nationality values.
SelectedNationalities =
CONCATENATEX (
VALUES ( data[Nationality] ),
", "
)
Is that what you were looking for?
Regards,
Owen
hi
It would be perfect but it doesn't work.
My measure (exactly the one you wrote) is not in error, and it finds the field nationality but the only value that is displayed is the Comma.
2 values selected