Forum Discussion
Dynamic text returning multiple text values
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 ...
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 measureMarket concat = CONCATENATEX(DISTINCT('Table'[Market]);'Table'[Market];",")
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.
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];",")