how to assign products to specific ID/OPP Name

[YASHASHRI]

Hi,
I am facing one scenario where i have following data.

Opp Number	Products
111	TV
112	Smartphone
113	Tablet
111	Smartphone
111	Refrigerator
112	Camera

And I want this result

Opp Name	Solution
111	TV, Smartphone, Refrigerator
112	Smartphone, Camera
113	Tablet

In short all the products that a specific OPP Name took should be assigned in above format.
How can we do this?
Note: OPP Name and Products coming from different table but have connect between them.

Thanks in advance.

[YASHASHRI]

opp number and product is in different table. and does not have direct relationship between then.
Any other solution ?

[eliasayyy]

please provide with more details how do the 2 tables looks like what are the columns any common column?

[eliasayyy]

hello @YASHASHRI 

Create a measure 

Opp Measure = 
VAR SelectedOpp = SELECTEDVALUE('Table'[Opp Number])
RETURN
CONCATENATEX(
    FILTER('Table', 'Table'[Opp Number] = SelectedOpp),
    'Table'[Products],
    ", "
)

or this measure

Opp Measure = 
CALCULATE(CONCATENATEX(
    'Table',
    'Table'[Products],
    ", "
),ALLEXCEPT('Table','Table'[Opp Number]))

if it solved your issue please accept as solution