Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
Create a measure and use that
concatenateX(Table, Table[Country], ", ")
Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24
Create a measure and use that
concatenateX(Table, Table[Country], ", ")
Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24
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:
Thanks once again for your help and prompt response!!
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |