How to show multiple text entries in a single column?

[JasonWhitehouse]

Hi,

Hoping someone can help explain how to show multiple text entires in a single column.

Currently I have selected 'Count (Distinct)' on '# countries' which returns the below table: 

However, in the same table I also want to see who the countries are. If I change 'Count (Distinct)' to 'Don't summarize' then I get the below view, but then each country is shown on a new row:

I'd like to have it where on a single row it shows that for a Company 'ie Crystal Martin', they operate in 2 countries, and those countries are show as 'Bangladesh, Sri Lanka'

Is this possible? Feels like an easy one but I haven't been able to find a solution.

Thanks in advance!

[amitchandak · Accepted solution]

@JasonWhitehouse ,

Create a measure and use that

concatenateX(Table, Table[Country], ", ")

Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24

[JasonWhitehouse]

Thanks so much @amitchandak!

The solution you provided returned the following:

Supplier Countries =

concatenateX(Table, Table[Country], ", ")

However, because I wanted distinct country values only, there was a solution in the link to the video you provided:

Supplier Countries =

    concatenateX(VALUES(Table[Country]), [Country], ", ")

Thanks once again for your help and prompt response!!