topic Re: CONCATENATEX using a virtual table from a variable in DAX Commands and Tips

CONCATENATEX using a virtual table from a variable

dataconsole — Tue, 03 Jan 2023 17:37:48 GMT

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!

Re: CONCATENATEX using a virtual table from a variable

tamerj1 — Tue, 03 Jan 2023 18:18:05 GMT

Hi dataconsole

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

Re: CONCATENATEX using a virtual table from a variable

dataconsole — Wed, 04 Jan 2023 09:38:50 GMT

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