topic Re: Concatenatex with summarize in DAX Commands and Tips

Concatenatex with summarize

SRobbo1990 — Thu, 04 May 2023 08:56:07 GMT

Hi All,

I'm currently trying to concatenate a list of suppliers (supplier table) by an Trip ID (itinerary item table) (as below);

So that it would show Trip Id 10000175 with the full list of suppliers concatenated

I've tried to use the following command;

CALCULATE (

CONCATENATEX(

SUMMARIZE('Itinerary Item', Supplier[Supplier Name]),

Supplier[Supplier Name],

", ",

[Supplier Name], ASC

)

Unfortunately this measure just throws back a full list of all the suppliers in the supplier table.

Any advice?

Thanks

Re: Concatenatex with summarize

Mahesh0016 — Thu, 04 May 2023 10:05:15 GMT

SRobbo1990

CONCATENATE =
VAR Tables =
SELECTCOLUMNS ( F, "Comments", F[Comments] )
RETURN
CONCATENATEX ( Tables, [Comments], "," )

SRobbo1990 If this post helps, then please consider Accept it as the solution and give Kudo to help the other members find it more quickly.

Re: Concatenatex with summarize

ERD — Thu, 04 May 2023 10:23:42 GMT

SRobbo1990 , I don't know how your data model looks like, but you can try to use the same table: