topic Re: CONCATENATEX MATRIX NO DUPLICATES in DAX Commands and Tips

CONCATENATEX MATRIX NO DUPLICATES

spandy34 — Wed, 10 Apr 2024 17:19:42 GMT

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?

Greg_Deckler — Wed, 10 Apr 2024 18:08:53 GMT

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

spandy34 — Thu, 11 Apr 2024 07:16:02 GMT

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

Greg_Deckler — Thu, 11 Apr 2024 13:19:54 GMT

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 — Thu, 11 Apr 2024 18:34:59 GMT

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