Need help in mapping and showing multiple values if exists

[A9kurs]

Hi Everyone,

Need help , I have two table ID and PM , In ID table there are two columns and "Item" & "Item Desc". Items are unique in this table.

PM table has columns "Item" & Co .  In this there are duplicate Items and some of them have diffrent Co . I want to show Items from ID table and co from PM table but if there are multiple Co then show them by comma seprated.

ID:

Item	Item Desc
100	dadsd
105	sadd
110	asdd
115	dsad
120	dasd
125	adsda
130	wsad
135	uy
140	j
145	fdget
150	ewrtwe

PM:

Item	Co
100	220
100	420
105	220
105	420
105	421
105	422
105	423
110	220
110	420
110	421
110	422
115	220
120	220
125	420
125	220
125	420
125	421
130	422
130	423
130	220
135	420
135	421
135	422
135	220
140	421
145	422
150	220

Output: 

Item	Item Desc	Co
100	dadsd	220 , 420
105	sadd	220,420,421,422,423
110	asdd	220,420,421,422
115	dsad	220
120	dasd	220
125	adsda	220,420,421
130	wsad	220,422,423
135	uy	220,420,421,422
140	j	421
145	fdget	422
150	ewrtwe	220

please help and appreciate if you can send Pbix.

Thanks in advance.

[jdbuchanan71 · Accepted solution]

@A9kurs 

Assuming the tables are joined on Item, you can use a measure like this.

Co List = IF ( HASONEVALUE ( 'ID'[Item] ), CONCATENATEX ( DISTINCT(PM[Co]),PM[Co],", ") )

I have attached my sample file for you.