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.

Collapse allCurriculum

  • 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


This content is also available in the collection:
DAX Patterns collection
Student Rating
7 ratings
Student Reviews (1)
  • Claudio Trombini (Feb 8, 2021)

    always n.1!!!