Report Portal

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.

 

The CALCULATE and CALCULATETABLE function in DAX transform existing row contexts into an equivalent filter context. This transformation is called context transition. A complete description is available in the article, Understanding Context Transition.

Read more...

 

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.