Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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?    
Need Help
  • MattAllington's avatar
    MattAllington
    5 years ago

    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. 

TheBIGuy_PBI's avatar
TheBIGuy_PBI
Icon for Helper II rankHelper II
3 years ago

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's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
3 years ago

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