ALL DAX Expression blocking other filters

[Anonymous]

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.

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

Try to use ALLSELECTED(Table).
ALLSELECTED

The definitive guide to ALLSELECTED

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

Use ALL(Table [Column]) instead.
If you use  ALL(Table) it removes filters on all the fields in the table

[Anonymous]

Thank you for your reply.
I did but giving me wrong number. Actually, exact same number as using without all function.