DAX Patterns: Parameter table
These are in-depth video lectures of the Parameter table pattern.
This pattern is used to create parameters in a report, so that users can interact with slicers and dynamically change the behavior of the report itself. For example, a report can show the top N products by category, letting the users decide through a slicer if they want to see 3, 5, 10 or any other number of best products. The values available for a parameter must be stored in one or more disconnected tables, which do not have a relationship with any other tables of the same model. This chapter includes several examples with the parameter table, but this pattern has an even broader range of application.
Students have access to a private discussion area where they can interact with the instructors asking questions related to the lectures and the exercises.
- About the Parameter table pattern
- Changing the scale of a measure
- Multiple independent parameters
- Multiple dependent parameters
- Selecting top N products dynamically