DAX Patterns: Ranking

These are in-depth video lectures of the Ranking pattern.

This pattern shows several techniques to assign a ranking position to customers, products, or other entities in a model: The ranking can be used to highlight, filter, or group entities. Ranking can be either static or dynamic. Static ranking assigns to each product a ranking position that is not affected by filters, whereas in dynamic ranking the position is computed every time the user interacts with the report. For example, in dynamic ranking the year selected in the report defines a new calculation of the ranking value.

Collapse allCurriculum

  • Ranking

    • About the Ranking pattern
    • Introduction
    • Static ranking
    • Dynamic ranking
    • Showing the top 3 products by category


This content is also available in the collection:
DAX Patterns collection
Student Rating
7 ratings
5-star Reviews (2 of 2)
  • Santosh Raghunath (Aug 30, 2020)

    As Always, Marco and Alberto are the best !!

  • susan greenwood (Aug 24, 2020)

    This was clear, concise and useful.