Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

In Power BI hierarchy, need to show parent values on parent instead of aggregation of child values

Employee example hierarchy.jpg

We are using a hierarchy matrix.  For the roll up parent level  the options for the columns are only aggregations of the lower level line items such as "First" "Last" or "Count".

But the higher level record has it’s own values for those fields. "Status", "ETA". Which are independent from the child records.

Instead we need a way to show the values from the parent record at the parent level not an aggregation of the children.

For example in the screenshot there is a hierarchy of Manager to employees under him.  But on the Manager's row it doesn't show aggregate data for all the salaries Start Dates, etc. of the employees under him, it shows the field values for his record.

1 REPLY 1
vanessafvg
Super User
Super User

@Anonymous  will path work for you?

 

https://docs.microsoft.com/en-us/dax/path-function-dax





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors