Average by category quick measure

[Anonymous]

Average Parts per Day =
AVERAGEX(
KEEPFILTERS(VALUES('UGUExports'[Occured].[Day])),
CALCULATE(COUNTA('UGUExports'[Part]))
)

The above formula is a quick measure I use to calculate the average parts per day submitted to my database. This formula works fine, but when I manually calculate the average parts submitted per day I get a value off by 8 parts per day. 

What I think is happening is that the above formula is calculating the average based on the dates listed in the [occured] column. What I need is it to calculate the average based on all days between firstdate[occured] and lastdate[occured]. 

Basically, I need the formula to account for days in between submission dates too. 

Can someone help with creating a formula to accomplish this? I am new to Power Bi and would really appreciate the guidence.

Thanks in advance.

[Anonymous · Accepted solution]

Just incase anyone else has this same question I found a easy work around. I dont know I didnt try this sooner actually.

Average Parts Per Day = COUNT(UGUExports[Part])/COUNT(Range[Date])

The table :"Range" in the above formula is a separate table I made from the "Occured" column I mentioned in the original question.

Here is the formula for that:

Range = CALENDAR(FIRSTDATE(UGUExports[Occured]),LASTDATE(UGUExports[Occured]))