Forum Discussion
how to combine text in multiple rows- DAX
I have a table which contains employeess' self-evaluation (column "Achievement"). Is there a way to filter the data by employee and combine them into one measure?
MattAllington
Community Champion
Community ChampionIf you just want to combine all rows into a single text measure, you can use concatonatex with a pattern like this.
CONCATENATEX(filteredTable,filteredTable[Acheivement],", ")
the filtered table could be done in different ways, including just passing the table name and adding the employees name into the rows section of a matrix.
MarkyMark1
Advocate I
Advocate IHi Matt is there are way to get this to only Concatenate unique values? Thanks.
- MattAllington
Replace "filteredTable" with VALUES(filteredTable[Column])
- MarkyMark1
I got an error with the measure "a table of multiple values was supplied when a single value was expected". I did manage to solve this using a similar solution you provided below with the dimension table linked to the fact table. Thanks.