Power Matrix visual

[KPalmer2022]

I have a table with a [Feet] = vlookupvalue (numerical value) from a reference table for a value by individual record. I need to have a matrix that will summarize the value [Feet] for a top level group and then multiple sub-level groups and yet show the drilld own of the individual records/rows [FEET] of each record such that for example: 

	FEET	ROW TOTALS
PART XYZ	60	60
SHIFT A	60	60
Line-3	30	30
Record 1	10
Record 2	10
Record 3	10
Line-4	30	30
Record 1	10
Record 2	10
Record 3	10

When I use a Matrix visual, I get close, but each individual record sahows as a total and not the individual record values?

[v-saisrao-msft]

Hi @KPalmer2022,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[v-saisrao-msft]

Hi @KPalmer2022,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.

[v-saisrao-msft · Accepted solution]

Hi @KPalmer2022,

I have reproduced the issue using sample data in Power BI Desktop and was able to achieve the expected output where parent levels show aggregated totals while individual record rows display their actual Feet values. I have attached the PBIX file below for your reference.

Thank you.