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 g...
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.
PaulDBrown
Community Champion
Community ChampionUse ALL(Table [Column]) instead.
If you use ALL(Table) it removes filters on all the fields in the table
Thank you for your reply.
I did but giving me wrong number. Actually, exact same number as using without all function.