topic Re: Combine concatenatex and group by to lerge text from several lines by id in DAX Commands and Tips

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

Anonymous — Mon, 31 Mar 2025 07:58:57 GMT

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 ?

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

Cookistador — Mon, 31 Mar 2025 08:16:49 GMT

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 ?

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

v-kathullac — Mon, 07 Apr 2025 11:59:34 GMT

Hi Anonymous ,

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.

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

v-kathullac — Fri, 11 Apr 2025 11:42:50 GMT

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.

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

v-kathullac — Thu, 17 Apr 2025 16:04:34 GMT

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.