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.

Curriculum

  • Parameter table

    • About the Parameter table pattern
    • Introduction
    • Changing the scale of a measure
    • Multiple independent parameters
    • Multiple dependent parameters
    • Selecting top N products dynamically

Collection

This content is also available in the collection:
DAX Patterns collection
Student Rating
5.0
2 ratings
0%
0%
0%
0%