How to create hierarchy for measure based dimensions?

[mohammed_inf]

Hello,

I have a dataset with Birthdate, I have calculated the age using measure based dimensions as i want to group age ranges together.

Now i want to add a hierarchy to drill down to the exact Age, Example: 3 Employees 30-40 years when drill down it shows each employee exact Age.

[VijayetaSharma]

Hellomohammed.inf,

You can not achieve this at story level.

Workaround:

As most of the time bucket definition do not change, you can opt to create them at story level and then create account based hierarchy. If you do it model level you get to choose the drill down at story level.

Don't forget to up-vote and accept, if it helped. 🙂

Vijayeta

[mohammed_inf]

Thank you, but should i calculate the age to a new column in the model then make it a child of birthdate?, and if so, what is the formula for doing it.

thank you in advance.