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.

Curriculum

  • Hierarchies

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

Collection

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