Concatenate multiple rows using a DAX measure

[Chewbaklava]

Hi all,

Here is an example table that i'm trying to write a measure for. My goal is to output a concatenated string of participants for each unique ID.

ID	Participant
001	John
001	Terry
001	Albert
002	Susan
002	Roger
003	Sally
003	Tom
003	Chewbaklava

Participants Conc = CALCULATE(CONCATENATEX(table, <expression>, "; ")

I'm struggling with the expression piece.

My visual will have columns: ID & [Participants Conc]:

ID	Participants Conc
001	John; Terry; Albert
002	Susan; Roger
003	Sally; Tom; Chewbaklava

Thanks for any suggestions or advice

[v-easonf-msft · Accepted solution]

Hi, @Chewbaklava 

Please try formula like

Participants = CONCATENATEX(FILTER('Table','Table'[ID]=MAX('Table'[ID])),'Table'[Participant],"; ")

Best Regards,
Community Support Team _ Eason

[HotChilli]

Keep it simple.

Check out the example here

https://learn.microsoft.com/en-us/dax/concatenatex-function-dax