Average for matrix columns

[Darwell]

I have this matrix table which is showing two different meeting rooms. (EP.02.M01) and (EP.02.M02) Then have a slice which allows me to adjust the date range.  The values in the rows shows, displays how many chairs were used with the hour column.

What I want to get out of this is an acurate average, for example meeting room M02 at 10 am added up to 6 chairs used over the 4 days. So 6/4 = 1.5 (This is the vaule that I want). I can only figure out the total days 6/5 = 1.2, which isnt a true reflection. 

Just on a side note, this data is coming from a direct quary.

Thank you in advance

 

[Anonymous · Accepted solution]

Hi @Darwell 

Please read this example:
First of all, I create a set of sample:

Then add a measure:

Measure = 
CALCULATE(
		COUNTROWS('Table'),
		'Table'[Column1] <> BLANK()
	)

The result is as follow:

^{Best Regards,}

^{Zhengdong Xu}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}