Average of Count per Hour over a date range using only a specific day of the week

[rcarrinsp]

Hello,

I'm having trouble with the DAX formula to generate the average of the counts over a period of time.

As you can see by this screenshot, the AVERAGE comes out to be the same as the COUNT.

 This is the formula I'm using:

but, I've tried multiple varations of it:

1.

AVERAGEX(
KEEPFILTERS(VALUES('Incident'[OwnedByTeamAssignedTimeHour])),
(COUNTA('Incident'[OwnedByTeamAssignedTimeHour]))
)

2.
CALCULATE (
DIVIDE ( [Total Tickets], DISTINCTCOUNT ( Calendar[WeekID] ) ),
FILTER (
ALL ( calendar ),
calendar[WeekID]
>= MAX ( calendar[weekID] ) - 12
&& calendar[WeekID] <= MAX ( calendar[WeekID] )
),values(calendar[day])
)

3.
AVERAGEX(
SUMMARIZE(
Incident,
Incident[OwnedByTeamAssignedTimeHour],
"Count",
COUNT('Incident'[OwnedByTeamAssignedTimeHour])
),
[Count]
)

They all just produce the COUNT.

Additional info:  I took the DATE/TIME field, and split out the Date and Time, and then I rounded the TIME, so that I could COUNT how many tickets came in during that time, so my data looks like this:

Anyone have an idea of why I'm not able to generate the actual AVERAGE?

Thanks in advance for your help!

RC