Capturing user selections with parameter tables
An alternative method of 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, such as business user selections, and compute the corresponding scenario logic.
