Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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.
@Anonymous will path work for you?
https://docs.microsoft.com/en-us/dax/path-function-dax
Proud to be a Super User!