Launch Offer - 20% OFF on SSAS Tabular Video Course

Filter Context

ARTICLE

Context Transition and Expanded Tables

This article describes how table expansion and filter context propagation are important DAX concepts to understand and fix small glitches in DAX expressions.

ARTICLE

Propagate filters using TREATAS in DAX

This article describes how to create a virtual relationship in DAX using the TREATAS function, which is more efficient than approaches based on INTERSECT or FILTER.

ARTICLE

Filter Arguments in CALCULATE

A filter argument in CALCULATE is always an iterator. Finding the right granularity for it is important to control the result and the performance. This article describes the options available to create complex filters in DAX.

ARTICLE

Time Intelligence in Power BI Desktop

In Power BI Desktop (as of February 2016) you have to use DAX to apply calculations over dates (such as year-to-date, year-over-year, and others), but you do not have the Mark as Date Table feature. This article describes which scenarios are impacted and the possible workarounds.

ARTICLE

Understanding Context Transition

The context transition in DAX is the transformation of row contexts into an equivalent filter context performed by CALCULATE and CALCULATETABLE. Managing this behavior is the next step in learning DAX once you understand row context and filter context. This article provides the basics of context transition.

ARTICLE

Row Context and Filter Context in DAX

Understanding the difference between row context and filter context is important to use DAX correctly. This article introduces you to these two concepts.

ARTICLE

All the secrets of SUMMARIZE

SUMMARIZE is a function that looks quite simple, but its functionality hides some secrets that might surprise even seasoned DAX coders. In this article, we analyze the behavior of SUMMARIZE, in order to completely describe its semantic. The final advice might surprise you: we will suggest to avoid the use

ARTICLE

AutoExist and Normalization

The autoexist feature used by MDX queries sent to an Analysis Services or Power Pivot data models can have different behaviors depending on the normalization level. This article describes these differences and provides best practices to avoid unwanted results.