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.

Students have access to a private discussion area where they can interact with the instructors asking questions related to the lectures and the exercises.


  • 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

Training Platform

This course is conducted through our training platform which is immersive and designed to facilitate your experience.

Discover all the features

Student Rating
5 ratings
Student Reviews (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.