Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
Thanks!
Solved! Go to 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!
@Anonymous , Try like
CALCULATE(DISTINCTCOUNT(Tickets[client_id]),FILTER(all(Tickets),Tickets[date]>MIN('Acciones Promocionales'[DisponibleDesde]) && Tickets[date]<MIN('Acciones Promocionales'[DisponibleHasta]))
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!
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |