Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with DAX

Hi all,

 

I'm creating a measure that its ok, but I want the same number without taking count of (month)

 

B_ClientsPromo has to be always 170 like in may. Here's the formula:

 

B_ClientsInPromo =

CALCULATE(DISTINCTCOUNT(Tickets[client_id]),FILTER(Tickets,Tickets[date]>MIN('Acciones Promocionales'[DisponibleDesde])&& Tickets[date]<MIN('Acciones Promocionales'[DisponibleHasta]))

 

 

Thanks!

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi amitchandak , Thanks! I've been able to extend the value to all months, but now the value is incorrect (1026 instead 170):

     

     

    Any ideas? The truly clients who have bought in may are 170:

     

    Thanks for all!

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Try like

     

    CALCULATE(DISTINCTCOUNT(Tickets[client_id]),FILTER(all(Tickets),Tickets[date]>MIN('Acciones Promocionales'[DisponibleDesde]) && Tickets[date]<MIN('Acciones Promocionales'[DisponibleHasta]))

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi amitchandak , Thanks! I've been able to extend the value to all months, but now the value is incorrect (1026 instead 170):

       

       

      Any ideas? The truly clients who have bought in may are 170:

       

      Thanks for all!

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak solved! Report level filters 😉

     

    Thanks again!