How to display duplicate values from one column based on values in another column

[ASingh15]

Hello Everyone,

I am new to powerbi and trying to figure out the bese solution for grouping the the values in ID column based on values in the code column. Below is the table for reference.

ID	Code
1	ABC
1	ABC
1	ABCD
2	ABC
3	ABC
4	XYZ
4	XYZ

This is what I want to display in the table visual:

ID	Code
1	ABC & ABCD
2	ABC
3	ABC
4	XYZ

Any help is greatly appreciated. Thank you!

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

One of ways is to use CONCATENATEX DAX function in a measure.

Code measure: =
IF (
    HASONEVALUE ( Data[ID] ),
    CONCATENATEX ( DISTINCT ( Data[Code] ), Data[Code], " & " )
)

[ASingh15]

Thank you for your prompt response! This solution worked perfectly for my use case. I hope I learn tricks and trade from super users like you. I greatly appreciate your assistance!