I have tried looking through the support forum here and I haven't found what I'm looking for, so please bear with me. I have a standard bar charts with three different levels to show average developer productivity. At the highest level, I have the sprint iteration ID. I can then drill down on that to see a list of all developers and finally the third level (i.e. the most detail) is when I drill down on that, I can see that actual work that the developer has accomplished during the given sprint.
The problem is that at each level I want an average and I cannot figure this out - it could very well be that I'm still learning Power BI. The the lowest level, I can easily calculate the average amount of work per day and I have a card on my dashboard to show that. However, if I drill up to either of the previous two (higher) levels, I still want an average but I want the context of the average to be different. In other words, at the highest level, I want the one average to show the average number of hours across all iterations and at the mid level, I want it to represent the average number of hours per developer - for that given sprint (whichever one I drilled down into).
Do I need to create temporary tables to summarize at the first and second levesl - and somehow have the dashboard know which table to base the average on?
I hope that this is clear - and if someone could help me out, I'd really appreciate it!
Rick
