topic Re: How to show multiple text entries in a single column? in DAX Commands and Tips

How to show multiple text entries in a single column?

JasonWhitehouse — Tue, 04 Oct 2022 09:26:16 GMT

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!

Re: How to show multiple text entries in a single column?

amitchandak — Tue, 04 Oct 2022 09:40:18 GMT

JasonWhitehouse ,

Create a measure and use that

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

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

Re: How to show multiple text entries in a single column?

JasonWhitehouse — Tue, 04 Oct 2022 10:06:51 GMT

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!!