Combine concatenatex and group by to lerge text from several lines by id

[VincHawthorne]

Hello eveyone !!

There is a problem I don't manage to solve ...

I have  in my model FAI_1, DIM_1, DIM_2 etc...  :

I need on a table, one line per client, with a list of all the product name's concatenate.

I manage to concatenate all the product name's and assign this measure to all clients, but so far I don't know how to obtain a list by client.

Can you help me ?

[v-kathullac]

Hi @VincHawthorne ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @VincHawthorne ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @VincHawthorne ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[Cookistador]

I made a small test with the followin example

Table contains the following data:

NameID

bob	A
Julien	A
Robert	A
bob	B
Julien	B
bob	C

and for table2

idProduct

A	Boots
B	Gloves
C	Headset

The following dax measure

Test =

VAR _seluser =

    SELECTEDVALUE ( 'Table'[Name] )

RETURN

    CONCATENATEX (

        FILTER ( 'Table', 'Table'[Name] = _seluser ),

        RELATED('Table (2)'[Product]),

        UNICHAR(44)

    )

Returns the following table:

Is it what you need ?