Hands-On Business Intelligence with DAX

Variable nesting

It is possible to nest variables within the declaration of another variable, which offers multiple levels of scope. Each level of variable nesting starts with the VAR keyword and ends with the RETURN keyword. An expression may only refer to variables that have been declared within the same level of scope or higher.

The following measure definition is an example of variable nesting:

NestedVariableExample1 = // The first level of scope is defined by the first VAR keywordVAR varLevelOneA = "Level 1"VAR varLevelOneB =     // The second level of scope is defined using the VAR    // keyword in the definition of this variable.    // Variables within this scope can access variables from    // this level or from the first level of scope. VAR ...