Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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 ?

 

Need Help
  • davehus's avatar
    davehus
    4 years ago

    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.

3 Replies

  • davehus's avatar
    davehus
    Icon for Memorable Member rankMemorable Member
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

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