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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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