topic Re: how to assign products to specific ID/OPP Name in DAX Commands and Tips

how to assign products to specific ID/OPP Name

YASHASHRI — Fri, 28 Jul 2023 10:48:50 GMT

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.

Re: how to assign products to specific ID/OPP Name

eliasayyy — Fri, 28 Jul 2023 11:09:58 GMT

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

Re: how to assign products to specific ID/OPP Name

YASHASHRI — Tue, 01 Aug 2023 06:02:55 GMT

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

Re: how to assign products to specific ID/OPP Name

eliasayyy — Tue, 01 Aug 2023 06:22:52 GMT

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