Large and complex Power BI datasets with many measures may have one or multiple measure support tables. As shown in the previous chapters, these hidden tables don't contain data and aren't refreshed with the dataset, but serve as the home table for commonly used DAX expressions. Unlike DAX variables, hidden DAX measure expressions are globally available to other DAX measures and queries. Measure support expressions, therefore, serve as a staging and consolidation layer to simplify DAX measures.
The measure support table may contain any of the following types of expressions:
- KPI targets
- Current and prior periods
- Filter context information
The two measures described in the Measure support logic section of Chapter ...
