Forum Discussion
Avg Tickets on Helpdesk System per year
Hi, I'm building a report to show the average tickets per year logged on the IT helpdesk. The Helpdesk Dataset contains TicketID, Ticket Start Date. I joined this table with a custom Date Table w...
I even tried the below but still get 340 for FY 2022
Avg Tickets Per Year = AVERAGEX( VALUES('Date'[Fiscal Month Year]), CALCULATE(COUNTROWS(HelpdeskData)))