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?
If 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.
MattAllington
Community Champion
Community ChampionReplace "filteredTable" with VALUES(filteredTable[Column])
MarkyMark1
Advocate I
Advocate II 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.