Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hello good morning,
I have a customer table where I have created a custom column which identifies customers according to their sale, if 90 days ago it is customer 1, more than 90 customer 2 and the rest is customer 3
First I calculate the days since the last purchase with
RangoDias = DATEDIFF([FechaUltimaCompraCliente],NOW(),DAY)
Then I identify the customer
Tipo Cliente =
SWITCH(
TRUE(),
AND(Clientes_sql[RangoDias]>0,Clientes_sql[RangoDias]<=90),1,
Clientes_sql[RangoDias]>90,2,
3
)
Now what I want to do is count the number of rows (customers) of a particular type.
For example 2 customers, I have a matrix where they appear, now I would like the data of how many (in number) there are in that list.
Thank you.
Unless I'm misunderstanding, can you not just drop in a measure.
DISTINCTCOUNT('Customer'[CustomerName])
Put that in the matrix.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |