CONCATENATEX using a virtual table from a variable

[dataconsole]

Hello, 

I made a matrix visual listing counts of Customers, New customers and Repeat Customers.

I wanted to extract the name of the Repeat Customers (Repeat Customers Pseudo) using CONCATENATEX on my variable Repeat Customers . (see below matrix + DAX code)

The result is weird, the list of Repeat Customers Pseudo is one less than the numerical count of Repeat Customers

does someone see the trick ?

Thank you!

[tamerj1 · Accepted solution]

Hi @dataconsole 

Apparently you have at least one blank customer clrarly indicated by the comma at the beginning of the concatenated text. 

[dataconsole]

Thank you @tamerj1 !

Indeed the sheet with sales data was also filled with some fees  which were not related to sales, therefore customer. I forgot to filter by sales only