Why you should always filter columns and never filter tables with CALCULATE in DAX!
Related article
One of the few golden rules in DAX is to always filter columns and never filter tables with CALCULATE. This article explains the rationale behind the rule.
Read related article