The purpose of the Measure Support table is to centralize DAX expressions that can be reused by other measures. Since DAX variables are limited to the scope of individual measures, a set of hidden, intermediate measures avoids the need to declare variables for each measure. The intermediate, or branching, DAX measure expressions also make it easy and less error-prone to implement a change as all dependent DAX measures will be updated automatically. In this way, the Measure Support table serves a similar function to the parameter and staging query expressions, described in the previous chapter, for M Queries.
For this dataset, DAX expressions containing the ISFILTERED() and ISCROSSFILTERED() functions can be used to determine ...