Combine data from multiple rows

[MichaelWild]

I use a matrix visual to show an overview table on my report page and I am stuck with one of the columns.

My matrix visual looks like that - I am struggling with the last column "Impacted products":

ID_nr	Cause	Owner	Approver	Impacted products
123	Problem	Joe	Hugo
456	Issue	Hanna	Fritz
789	Failure	Laura	Paul

From a second table I receive the information about the Impacted products however they are in the following format:

ID_nr	Impacted product
123	Product A
123	Product C
123	Prodcut D
456	Product A
456	Product F
789	Product F
789	Product A
789	Product D
789	Product X

In the end I to end up with the final overview table like that:

ID_nr	Cause	Owner	Approver	Impacted products
123	Problem	Joe	Hugo	Product A, Product C, Product D
456	Issue	Hanna	Fritz	Product A, Product F
789	Failure	Laura	Paul	Product F, Product A, Product D, Product X

Unfortunately I cannot wrap my head around how to filter the data to come up with the desired outcome. 

Any help is greatly appreaciated.

[Jihwan_Kim · Accepted solution]

Impacted products measure : =

IF (

ISFILTERED ( Table1[ID_nr] ),

CONCATENATEX ( RELATEDTABLE ( Table2 ), Table2[Impacted product], ", " )

)

https://www.dropbox.com/s/7b201458if44ltg/michaelwild.pbix?dl=0 

[MichaelWild]

Thank you very much - works like a charm.