If you are working with SSAS Tabular, Power BI, or good ol' Power Pivot for Excel, you've likely run into a need for DAX, the formula and query language of these tools. A very common task is to augment, override, or otherwise modify a filter context. This sounds easy enough, but if you've had experience beyond simple filters, the syntax and behavior may seem confusing, or worse, counter-intuitive. The purpose of this presentation is to discuss the different types of filters, their behavior, and their interactions with other DAX formulas.
No material found.