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.
- About the Parameter table pattern
- Changing the scale of a measure
- Multiple independent parameters
- Multiple dependent parameters
- Selecting top N products dynamically
This course is conducted through our training platform which is immersive and designed to facilitate your experience.
- Claudio Trombini (Feb 8, 2021)