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).

Collapse allCurriculum

  • 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
4.9
8 ratings
87%
13%
0%
0%
0%
Student Reviews (2)
  • Amdi Silword (Dec 5, 2023)

    Very Good.

  • Claudio Trombini (Feb 5, 2021)

    top!!!!