How to remove duplicates from calculated column

[ashuaswinireddy]

I have a calculated column which was created using RELATEDTABLE

NAMES=

CALCULATE(CONCATENATEX(RELATEDTABLE('TABLE'),

[NAME],

    ","

))

What I currently have

ID	NAMES(CALCULATED COLUMN)
1	A,A,B,C,D,D
2	A,B,E,E,D,F,F
3	A,A,S,S,D,F,H
4	A,S,D
5	A,A

What I need:

1	A,B,C,D
2	A,B,E,D,F
3	A,S,D,F,H
4	A,S,D
5	A

Can you please let me know how to get distinct values for a calculated column.

Thank you!

[vicky_ · Accepted solution]

Try something like:

Unique IDs = CONCATENATEX(
    DISTINCT(SELECTCOLUMNS(RELATEDTABLE('Table'), "values", 'Table'[Value])), 
    [values], 
    ", "
)