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.
- About the Hierarchies pattern
- Detecting the current level of a hierarchy