Forum Discussion
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:
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.
Hi, Anonymous
Try to use ALLSELECTED(Table).
ALLSELECTEDThe 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.
3 Replies
- PaulDBrown
Community Champion
Use ALL(Table [Column]) instead.
If you use ALL(Table) it removes filters on all the fields in the table- AnonymousNot applicable
Thank you for your reply.
I did but giving me wrong number. Actually, exact same number as using without all function.
- v-angzheng-msft
Community Support
Hi, Anonymous
Try to use ALLSELECTED(Table).
ALLSELECTEDThe 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.