You searched "Context"
        158 results
video –

Deep dive into DAX evaluation context

Ever struggled with a formula in DAX that does not compute what you want? It has happened to us many times, and we know that the problem is ALWAYS related to the evaluation context. Filter context, row context, and context…  Watch now

article –

Context Transition and Filters in CALCULATE

This article explains how the context transition interacts with the filter arguments of a CALCULATE function in DAX. This is important in order to avoid unexpected results with complex calculations made in filter arguments.  Read more

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.  Read more

blog post –

Don’t ignore the Context Transition in #dax

Almost 3 years ago I wrote an article with the rules for DAX code formatting . If you quickly look at the article, you might think that it is all about readability of the code, and this is fundamentally true. But there two rules that have a particular  Read more

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…  Read more

article –

Usage of dates argument in a row context

Several Time Intelligence functions in DAX use a <dates> argument, which has a special behavior because it can be expressed by using both a column reference syntax, a table expression or a Boolean expression.  Read more

video –

DAX Evaluation Context

Learning evaluation contexts in Data Analysis Expression (DAX) is fundamental to understanding the behaviour of this language, and to being able to write correctly functioning formulas for your desired calculations. Marco Russo teaches you these important concepts in this 50-minute…  Watch now