Forum Discussion

ContabilidadBI's avatar
ContabilidadBI
Icon for Helper III rankHelper III
9 years ago
Solved

Active Clients

Hello guys,   I want to create a simple measure that calculates the number of active clients, considerating active clients, clients who bought something in the last 3 months for example. If a clien...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    HI ContabilidadBI.

     

    If these tables has relationship, you can try to use below formula to calculate the distinct count.

     

    ActiveClients = CALCULATE ( DISTINTCOUNT( Sales [ClientKey]), FILTER(ALL(Calendar),[Date]>= Date(Year(Today()),Month(Today())-3),day(today())))

    In addition, if above formula not works, I'd like to suggest you modify the 'cross filter direction' option to 'both' and try again.

     

    Regards,

    Xiaoxin Sheng

ContabilidadBI's avatar
ContabilidadBI
Icon for Helper III rankHelper III
9 years ago

Hi Anonymous,

 

Thank you for your help. I am trying to use the formula but I have a problem, this is the formula with the names of my tables/columns:

 

ClientesActivos = 
CALCULATE(
	 DISTINCTCOUNT(Facturas[CodCliente]);
	 FILTER(
		 ALL(Calendario);
		 Calendario[Fecha]>= CALENDAR(YEAR(TODAY());MONTH(TODAY())-3);DAY(TODAY())))

I get an error that says that too many arguments are passed to the FILTER function, which only admits two. Am I doing anything wrong? The sales table (Facturas), and the calendar table (Calendario) are related, as you can see in the pic.

 

Thanks again.

 

 

AmalrajRRD1's avatar
AmalrajRRD1
Icon for Helper II rankHelper II
9 years ago

Now I want to find latest month, latest quarter and Latest year differences value.

 

How will do it ?

 

Thanks.

 

 

  • ContabilidadBI's avatar
    ContabilidadBI
    Icon for Helper III rankHelper III
    9 years ago

    Bro, don't you have your own thread where me and others answered you? don't want to be rude but lets keep an order please.

     

    Thanks.