CONCATENATEX is providing duplicated result even when using values() ,distinct() or related table()

[Anonymous]

Hi , 
Can someone help me with this issue, While concatenating data in one single colum into row wise data, duplicates are coming, is there any way to achieve this without duplicates? I have tried with Values(), Distinct(), RelatedTable() dax function but it is not working as expected, is there any way to do this ?

[davehus · Accepted solution]

Hi @Anonymous ,

Try this 

CONCATENATEX(VALUES('# test_DRIVER_DASHBOARD'[CATEGORY]) ,'# test_DRIVER_DASHBOARD'[CATEGORY],",")

Values will read the column and return a unique set of data.

If this answers your question, please accept my solution.

[Anonymous]

Hi davehus,
Thank you so much this solved my problem .

[Anonymous]

Hi davehus,
Thank you so much this solved my problem 😁.