An alternative method of providing parameter functionality to users of Power BI reports is via dedicated parameter tables. In this approach, the parameter values of a table are either computed during the dataset refresh process, or are loaded as a one-time manual operation, such as in the Virtual Table Relationship recipe in Chapter 3, Building a Power BI Data Model. DAX measures reference this parameter table and other tables and expressions of the model to enrich the self-service analysis experience and support Power BI report development.
The example in this recipe involves providing simple visibility to four alternative scenarios to the baseline annual sales plan--10 and 20 percent above and below the baseline plan. An inline set of scenario values are embedded in the data model and DAX measures are used to capture filter context...