The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
User | Count |
---|---|
78 | |
73 | |
38 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |