Average of the subtotals in Power BI matrix

[Anonymous]

I am trying to get the matrix below to show average instead totals but I can’t get it to work. Any help on this is greatly approached.

I can share the sample pbix but not sure how. I have also added top 10 rows of the sample data as well

Date	Date	HourDesc	Location	Area	Labour_Hours
Fri, 19-Feb-21	Fri	0-1	E	R	0
Fri, 19-Feb-21	Fri	0-1	F	R	1
Fri, 19-Feb-21	Fri	0-1	G	R	0
Fri, 19-Feb-21	Fri	0-1	A	R	0
Fri, 19-Feb-21	Fri	0-1	H	R	1
Fri, 19-Feb-21	Fri	0-1	B	R	0
Fri, 19-Feb-21	Fri	0-1	D	R	1
Fri, 19-Feb-21	Fri	0-1	C	R	1
Fri, 19-Feb-21	Fri	1-2	A	R	0
Fri, 19-Feb-21	Fri	1-2	F	R	1
Fri, 19-Feb-21	Fri	1-2	H	R	0
Fri, 19-Feb-21	Fri	1-2	G	R	0
Fri, 19-Feb-21	Fri	1-2	B	R	0
Fri, 19-Feb-21	Fri	1-2	E	R	1
Fri, 19-Feb-21	Fri	1-2	D	R	0
Fri, 19-Feb-21	Fri	1-2	C	R	0
Fri, 19-Feb-21	Fri	2-3	A	R	0
Fri, 19-Feb-21	Fri	2-3	D	R	1
Fri, 19-Feb-21	Fri	2-3	E	R	0
Fri, 19-Feb-21	Fri	2-3	F	R	0
Fri, 19-Feb-21	Fri	2-3	H	R	0
Fri, 19-Feb-21	Fri	2-3	B	R	0
Fri, 19-Feb-21	Fri	2-3	C	R	0
Fri, 19-Feb-21	Fri	2-3	G	R	0
Fri, 19-Feb-21	Fri	3-4	D	R	0
Fri, 19-Feb-21	Fri	3-4	E	R	0
Fri, 19-Feb-21	Fri	3-4	F	R	0
Fri, 19-Feb-21	Fri	3-4	C	R	0
Fri, 19-Feb-21	Fri	3-4	B	R	0
Fri, 19-Feb-21	Fri	3-4	H	R	0
Fri, 19-Feb-21	Fri	3-4	G	R	0
Fri, 19-Feb-21	Fri	3-4	A	R	0
Fri, 19-Feb-21	Fri	4-5	A	R	0
Fri, 19-Feb-21	Fri	4-5	B	R	1
Fri, 19-Feb-21	Fri	4-5	D	R	0
Fri, 19-Feb-21	Fri	4-5	F	R	0
Fri, 19-Feb-21	Fri	4-5	E	R	0

Thanks,

Deevs

[amitchandak · Accepted solution]

@Anonymous , Try measures like

averageX(summarize(Table, Table[location], table[DayName], "_1", sum(Table[Labour Hour])),[_1])

[Anonymous]

@amitchandak Thanks it worked 🙂