concatenate all the values in the one single column to one cell of value , separated by ,

[powerbbbuuuuu]

Hi I am trying to concatenate the values in a single column with:

CONCATENATEX( 'tableName', 'tableName'[fieldName], ",")

However, the above formula does not work. Does anyone know the reason

[Ashish_Mathur]

Hi,

Does this measure work?

=CONCATENATEX(VALUES('tableName'[fieldName]),'tableName'[fieldName],",")

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file and show the expected result.

[Ashish_Mathur · Accepted solution]

Hi,

This measure works absolutely fine on the file you shared with me privately

=CONCATENATEX(VALUES('crmID-perVM'[crmID]),'crmID-perVM'[crmID],",")