Dax helped! Average a measure

[Anonymous]

hello

Please can someone advice.

I have a measure # connection which is built from COUNTROWS dax. It count number of rows of this Table1.

It has relationship between TIme dimesion and Date dimension

So when i put it in a table format, I got the right output below.

Now I want to be able to AVERAGE # connection. What I want to answer is how many connections at 08:00 in a month. But I dont know hot to put this in dax. Using the figures below the average should return 8.0625 (worked this out in excel). Can someone please help me.

Thank you for your advice

[Sean · Accepted solution]

So # Connections is a Measure built with COUNTROWS - okay!

How then is the total only 41? Shouldn't it be the sum of all those numbers which looks to be 129 / 16 days => 8.0625

What is the Measure formula?

EDIT:

The Denominator part of the Avg # Connections will most like have to be adjusted but this should help you...

Good Luck!

[Anonymous]

Anyone plz help?