how to combine text in multiple rows- DAX

[Anonymous]

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 · Accepted solution]

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. 

[MarkyMark1]

Hi 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.

[TheBIGuy_PBI]

HI Matt. This was really helpful and your solution worked for me as well, but I have a different challenge.
Is there a way to concatenate each record only in which the QuestionText is the same?

In other words, concatenate the records when the QUESTIONTEXT is the same?
Ideally I would have two concatenated records, one for each record as a result

Any help is appreciated

[MattAllington]

You need a dimension table for your QuestionText (create that in Power Query

Join the dimension table to your fact table

Use the dimension table in the visual (shown above).  Now there is only 1 record per question text instead of 1 record per answer

rewrite your concatenatex to refer to the dimenstion table as the first parameter

[Anonymous]

Thank you! That works perfectly.