Drill down on parent child hierarchy over time

[Eric667]

Hi there,

I was wondering if there is a way to combine a date drill down with a parent child hierarchy on three levels. In this case I want to drill down from Ad Networks, each containg several Ad Groups which in turn contain several Campaigns, and this over time. When I try this Power Bi distributes all values equally on the lower levels, much alike if there was no mapping between a sales and a date table. Is there an option to achieve this?

Cheers!

[MattAllington]

You can drill down on any number of different columns from the same or different tables as long as you have the relationships set up correctly and as long as the DAX formulas are written correctly for these relationships.  To give you a clearer answer you will need to provide more details about the tables, the relationships and the formulas.