Forum Discussion

ContabilidadBI's avatar
ContabilidadBI
Helper 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

Anonymous's avatar
Anonymous
Not applicable
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
Helper 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
    Helper 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
      Helper 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.