Dynamic text returning multiple text values

[Anonymous]

I have a table with a company name and budget. When i click on the company name i want to have a card with dynamic text that will change to show the names of the markets they are in. How do i make a measure like that that shows all the markets. I tried some things but i only get one market back and not all of them.

Thanks

[MFelix]

Hi @Anonymous ,

You should use the CONCATANEX formula to calculate this should be something similar to:

CONCATENATEX(Table, Table[Column], “,”)

Check the documentation for further explanation.

[Anonymous]

Hi @MFelix i am not sure this is what i am looking for. The markets are all in the same column. My data looks like that.

Company A             France

Company A             Germany

Company A             Japan

So company A is in 3 markets. If i use CONCATENATEX all i get is France multiple times for some reason.

[MFelix · Accepted solution]

Hi @Anonymous ,

As you can see below using the measure:

Market concat = CONCATENATEX('Table';'Table'[Market];",")

I achieve the expected result, are you making a measure or a column? Does your table have the Market more than one time per company?

If you have more than one value per company try the measure

Market concat = CONCATENATEX(DISTINCT('Table'[Market]);'Table'[Market];",")

[Anonymous]

Thank you so much @MFelix . I didn't put in the Distinct. that was my error. 

Many thanks