Videos. The Logic behind the Magic of DAX Cross Table Filtering. Automatic cross filtering between columns of the same table or related tables is a very powerful feature of DAX.
It allows a measure to evaluate to different values for different cells in a pivot table even though the DAX expression for the measure does not change. Filter context is the underlying mechanism that enables this magic behavior. But it is also a very tricky concept that even befuddles some DAX experts. SQL Server 2008 Analysis Services Performance Guide.