Trying to combine CONCATENATEX with DISTINCT

[Ayoeri]

I've got below table:

For each project I'm trying to concatenate a list of all colors in that project. So:

Or in short:

I used below function CONCATENATEX (FILTER ('Table', 'Table'[Project] = EARLIER ('Table'[Project])), 'Table'[Color], ", "). This does give me the list of all colors in the project but it shows them all:

In order to get to my desired result I want to take the duplicated colors out of the concatenated list. I have tried to work with the DISTINCT function as below but this did not give me the desired output.
CONCATENATEX (DISTINCT(FILTER ('Table', 'Table'[Project] = EARLIER ('Table'[Project]))), 'Table'[Color], ", ").

Any idea how I could get the duplicates out of this CONCATENATEX list?

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

expected result CC =
CONCATENATEX (
    SUMMARIZE (
        FILTER ( 'Table', 'Table'[Project] = EARLIER ( 'Table'[Project] ) ),
        'Table'[Colors]
    ),
    'Table'[Colors],
    ", "
)

[Ayoeri]

Thanks, that worked! I didn't consider the summarize function over the distinct.