Average - Tickets per day - Not all days are counted

[llaprosper]

Hello all,
I am a beginner, but I have already created a few reports successfully.
Now I have the following problem:

We have a ticket system where I want to show how many tickets are created on average per day.
In the database there is a column "CreatedDate".
I have linked this to my self-made table "Calendar".

Now I have created a measure.

Ticket Count = COUNT(Ticketing[TicketNumber])

So I have the number of tickets

Then I tried the following:

Average Ticket per day = AVERAGEX(VALUES('Calendar'[Date]),Ticketing[Ticket Count])

Now I also get results displayed.

But not from the average of ALL days, only from the days where also a ticket was created.
Mostly no tickets are created on weekends, so these days are not counted.
What can I do so that ALL days are counted? Including the days where no ticket was created (All days I select by slider)

best regards
Andreas

[johnt75 · Accepted solution]

Try

Average Ticket per day = AVERAGEX(VALUES('Calendar'[Date]),COALESCE([Ticket Count], 0))

[llaprosper]

thanks a lot. This works great