CONCATENATEX MATRIX NO DUPLICATES

[spandy34]

Hello

I have the following matrix where the Rows are the Mission Project Field, the column is the Row field and the Values is the following DAX

z_Names_Matrix = CONCATENATEX(

    'Name Main','Name Main'[Name],"," & UNICHAR(10))

How do I amend the DAX so it only displays the persons name once as opposed to repeating them as the matrix displays below?

@amitchandak @tamerj1 @danextian @goncalogeraldes @v-tangjie-msft @v-kaiyue-msft @Uzi2019 

[Greg_Deckler]

@spandy34 Try:

z_Names_Matrix = CONCATENATEX(
    DISTINCT('Name Main'[Name]),[Name],"," & UNICHAR(10))

[spandy34]

Hi @Greg_Deckler 

Thank you for your response.  I get the following error when I insert DISTINCT as you suggest

[Greg_Deckler · Accepted solution]

@spandy34 You didn't use my code. Your code has syntax errors and will not work because it is not the correct logic. Use exactly this:

z_Names_Matrix = CONCATENATEX( DISTINCT( 'Name Main'[Name] ) , [Name], "," & UNICHAR(10))

[spandy34]

Thank you very much - that has worked.  Sorry about not copying the DAX properly.  I appreciate your time.