O'Reilly logo

The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI by Marco Russo, Alberto Ferrari

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11. Handling hierarchies

DAX does not have any built-in function that provides calculations over hierarchies between attributes and entities. However, the underlying data model can include the definition of hierarchies used by client tools to simplify the browsing experience over data. A data model supports only regular hierarchies between columns of the same table, and does not have a native support for parent-child hierarchies.

In this chapter, you will learn how to create calculations over hierarchies and how to use DAX to transform a parent-child hierarchy into a regular hierarchy managed by the data model.

Computing percentages over hierarchies

When you have a hierarchy in the data model, a common requirement is a measure that has ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required