Forum Discussion
Return selected values in string?
I have a column with unique values in a standalone table (tableA). How do i create a measure that returns all these values in a single string that will update accordingly while filtering. I canno...
Try something like this:
= CONCATENATEX ( ALLSELECTED ( TableA[Column] ), TableA[Column], "," )
How would add in an additional column to the foregoing? Let's say for example that I have 2 columns: user name and email domain and the table looks like this
Col 1 Col 2
JennyX gmail.com
JennyX yahoo.com
Roberto ilovecats.com
JohnG ilovedogs.com
How would write a concat measure that could show all domains in a string that match the names in col 1 such that the output would be
JennyX gmail.com, yahoo.com
Roberto ilovecats.com
JohnG ilovedogs.com
???