CONCATENATEX using a virtual table from a variable

Question

Hello,&nbsp;&nbsp;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 .&nbsp;(see below matrix + DAX code)&nbsp;The result is weird, the list of Repeat Customers Pseudo is one less than the numerical count of Repeat Customers&nbsp;does someone see the trick ?&nbsp;Thank you!&nbsp;&nbsp;&nbsp;

tamerj1 · Accepted Answer

Hi&nbsp;dataconsole&nbsp;
Apparently you have at least one blank customer clrarly indicated by the comma at the beginning of the concatenated text.&nbsp;

Forum Discussion

CONCATENATEX using a virtual table from a variable

2 Replies

Related content

Fabric virtual table

GA availability for streaming connector virtual network

Power Virtual Agent

variables virtual tables

Using CONCATENATEX with FILTERS