Concatenatex with summarize

[SRobbo1990]

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

[ERD]

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

[Mahesh0016]

@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.