Concatenate distinct text value

Question

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.&nbsp;Thank you for help.&nbsp;

v-yalanwu-msft · Accepted Answer

Hi,&nbsp;thhmez7&nbsp;;
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 WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Concatenate distinct text value

2 Replies

Related content

Concatenate distinct values from column in Measure

concatenate values

CONCATENATE DISTINCT VALUES in Tooltip

Dynamic column concatenating distinct values

Concatenate rows values