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...
tackytechtom
Most Valuable Professional
Most Valuable ProfessionalHi jaus ,
How about just using the AVERAGE function on your data and letting the graphs do the grouping and filtering:
Here the DAX I used:
AvgMeasure = AVERAGE ( Table[Count of Ticket #] )
Let me know if this solves your issue 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/