Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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]))

 

 

markoss92_0-1631525251837.png

Thanks!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

 

markoss92_0-1631528305279.png

 

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

 

markoss92_1-1631528370283.png

Thanks for all!

 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

@amitchandak solved! Report level filters 😉

 

Thanks again!

amitchandak
Super User
Super User

@Anonymous , Try like

 

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

Anonymous
Not applicable

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

 

markoss92_0-1631528305279.png

 

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

 

markoss92_1-1631528370283.png

Thanks for all!

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.