Forum Discussion
Aggregating child records to parent Matrix Visualization
Hello,
I created a Matrix visualization, and I have a parent level, i.e. Northern Idaho Pod, which contains two forests (child). The Pod has it’s own estimate and should not be aggregated from the forests. However, Power BI wants to sum the forests to the Pod level, and I cannot figure out how to keep the original data, not summed:
This also occurs in my Bar Graph, so for the workarounds, I used just the regular Table vis, and created a stand-alone 1:1 relationship table for the bar graph.
Any thoughts on how to NOT sum child records to Parent records would be appreciated. Thanks!
1 Reply
- SpartaBI
Community Champion
BReyes00 hey, not sure that's what you meant but there isn't a native way in Power BI out of the box visuals to handle Parent Child hierarchies. There is however, a DAX pattern for that (it's more than a piece of code). Take a look at the patten here:
https://www.daxpatterns.com/parent-child-hierarchies/
In case it answered your question, please accept it as a solution to help the other members find it more quickly. Appreciate Your Kudos 💪
Showcase Report – Contoso By SpartaBI
Website Linkedin Facebook
This is SpartaBI!
