Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

ALL DAX Expression blocking other filters

Hello everyone,

 

I have a table out of three merged table and I use below dax to caculate active sales persons that we contact within last 90 days.

I have calendar table as well. Basically, I'm getting people between choosing min and max date and also contacted sales people within selected min calendar date. So, it is:

 

actives = CALCULATE(
DISTINCTCOUNT(agents_calls_appointments[_pk]),
FILTER(ALL('agents_calls_appointments'),
([last_meeting_date] >= MIN( 'calendar'[Date] ) && [last_meeting_date] <= MAX( 'calendar'[Date] )) ||
([last_meeting_date] > MIN('calendar'[Date])-90))
)

The problem is I have different filters on my page, and this calculation does not react with other filters.
Filters are connected with the table I use for calculation. So, Active Sales Executive doesn't react with other filters.
Also want to mention that interactions between visuals are on.

filtersactive sales executives
I think problem is coming from this ALL dax function. I believe I have to use it. I tried without ALL function but the calculation is giving me wrong number.
 
Any feedback is greatly appreciate it. Thank you.

3 Replies