Concatenate distinct text value

[thhmez7]

Hi,

I'd like to concatenate the column Brand. Here I created a column:

For Product G there are two data rows with Brand = n. If this is the case, the brand "n" should be displayed only once. It should be treated as a distinct value. So the result should be "n + U" for product G.

Thank you for help.

[v-yalanwu-msft · Accepted solution]

Hi, @thhmez7 ;

Try this dax about column.

Concate = 
CONCATENATEX (
    SUMMARIZE (
        FILTER ( ALL ( 'Table' ), [Product] = EARLIER ( 'Table'[Product] ) ),
        [Brand]
    ),
    [Brand],
    "+",
    'Table'[Brand], ASC
)

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[thhmez7]

thanks, looks good. my use case changed a bit, but it surely helps 🙂