Avg per Day by Month & YTD in Matrix

[connork]

Tables

Say I have 2 tables, one with monthly totals by customer and one that has the working days per month (see below).

Goal

Setup a matrix table that shows the average hours per customer per day by month and YTD.

Issue

I can't get the grand total of the rows to calculate correctly by customer and in total. 

Any ideas on how to get this to work in a matrix in PBI?  Just looking for concept of how to apporach this issue (if it is possible).

Thanks

[Phil_Seamark · Accepted solution]

Hi @connork

Please give this calculated measure a crack and let me know how you go

Measure = 
IF(
	ISFILTERED('TABLE2 - WORK DAYS'[Month]),
	DIVIDE(
		SUM('TABLE1-DATA'[Hours]),
		MAX('TABLE2 - WORK DAYS'[Working Days])
		),
		------ Grand Total Calc Here ------
		DIVIDE(
			CALCULATE(SUM('TABLE1-DATA'[Hours])),
			CALCULATE(SUM('TABLE2 - WORK DAYS'[Working Days])
			)
		)
 )

Here is the result I got

[connork]

Hi @Phil_Seamark,

Exactly what I needed - thanks!