DAX Patterns: Hierarchies

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

Many tables contain hierarchies to simplify the navigation in a report, like Category, Subcategory, and Product Name in a Product table. This pattern shows how to correctly identify the hierarchical level displayed in a report, in order to correctly implement a different calculation for each level of a user hierarchy in a Tabular model. For example, this technique is necessary to correctly compute a ratio-to-parent measure (% of Parent).

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


  • Hierarchies

    • About the Hierarchies pattern
    • Introduction
    • Detecting the current level of a hierarchy


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
2 ratings