DAX Patterns: Parent-child hierarchies

These are in-depth video lectures of the Parent-child hierarchies pattern.

Parent-child hierarchies are often used to represent charts of accounts, stores, salespersons and such. Parent-child hierarchies have a peculiar way of storing the hierarchy in the sense that they have a variable depth. In this pattern we show how to use parent-child hierarchies to show budget, actual and forecast values in a report using both a chart of accounts and a geographic hierarchy.

Collapse allCurriculum

  • Parent-child hierarchies

    • About the Parent-child hierarchies pattern
    • Introduction
    • Basic parent-child pattern
    • Calculations over the hierarchy
    • Chart of accounts hierarchy
    • Security pattern for a parent-child hierarchy


This content is also available in the collection:
DAX Patterns collection
Student Rating
7 ratings
Student Reviews (3)
  • Mira Abel (Dec 6, 2023)


  • Steven Gilbert (Jun 17, 2021)

    Excellent work guys!

  • Cho Joseph (Dec 9, 2020)

    quite smart.. it gives me a inspiration