Calculate Average number of tickets per month for 2021

[bahare76]

Hi Everyone, 

I have used the following measures for calculating the average tickets for 2020. 

Total Ticket = COUNT('Report Ticket'[Request ID])

NumofDistinctDates = DISTINCTCOUNT('Report Ticket'[Date].[Month]

Average = DIVIDE([Total Ticket],[NumofDistinctDates])

However, this measure didnt give the correct output when applying for 2021. This is because i dont have the data yet for April 21 onwards. I was wondering how can i correct this.

TQ

Bahare

[jdbuchanan71 · Accepted solution]

@bahare76 

Try it like this.

Average Tickets =
AVERAGEX (
    VALUES ( 'Report Ticket'[Date].[Month] ),
    CALCULATE ( COUNT ( 'Report Ticket'[Request ID] ) )
)

Or, if you want to keep the measures seperate your month count would look like this.

NumofDistinctDates =
CALCULATE (
    DISTINCTCOUNT ( 'Report Ticket'[Date].[Month] ),
    KEEPFILTERS ( 'Report Ticket'[Date].[Date] <= TODAY () )
)

[bahare76]

Thanks @jdbuchanan71 . It worked...