DAX does not allows us to calculate hierarchies directly. In fact there’s no DAX function that handles hierarchies. But we can calculate them using some tricks. In this article, I am going to explain how we can calculate percentages on a geographic data.
We have some of the following natural hierarchies in the database world.