Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi, @Chewbaklava
Please try formula like
Participants = CONCATENATEX(FILTER('Table','Table'[ID]=MAX('Table'[ID])),'Table'[Participant],"; ")
Best Regards,
Community Support Team _ Eason
Hi, @Chewbaklava
Please try formula like
Participants = CONCATENATEX(FILTER('Table','Table'[ID]=MAX('Table'[ID])),'Table'[Participant],"; ")
Best Regards,
Community Support Team _ Eason
Keep it simple.
Check out the example here
https://learn.microsoft.com/en-us/dax/concatenatex-function-dax
User | Count |
---|---|
59 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
87 | |
59 | |
52 | |
37 | |
21 |