Help with DAX

[Anonymous]

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!

[Anonymous]

@amitchandak solved! Report level filters 😉

Thanks again!

[amitchandak]

@Anonymous , Try like

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

[Anonymous · Accepted solution]

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!