Forum Discussion
How to return multiple values separated by commas (DAX)
Hi, everyone. I suppose that it is noobie question - but I can't find an answer. Pls, help. I have 2 tables and need to create a new one The first table contains Client ID and Source The second ...
Hi Anonymous ,
You can create the following table:
Table = ADDCOLUMNS ( SUMMARIZE ( FILTER ( Sold; Sold[Sold] = "YES" ); Sold[ClientID] ); "Source"; CONCATENATEX ( RELATEDTABLE ( Source ); Source[Source]; ", " ) )If you want a measure you should use:
Measure = CONCATENATEX(Source;Source[Source]; ", ")Then just filter out the Sold to yes on the filter of the visual.
