DAX Open Tickets, Closed Tickets Measure

Notes

Replace 'Tickets'[Status] with your own status column and values.

Requirements

• A Tickets table with a Status column.

How to use this measure

1. In Power BI Desktop, select the table that should hold the measure and choose New measure on the ribbon.
2. Paste the code, then replace the placeholder table and column names with your own. The My table names fields above do this for you.
3. Run it through the DAX Formatter if you want it laid out in your team's style.

Related DAX measures

• Overdue TasksCounts tasks whose due date has passed and that are not yet marked complete.
• Ticket BacklogCounts tickets that are still open as of the last date in the current filter context, a snapshot measure.
• SLA Met %Expresses the percentage of tickets resolved within their service level agreement target.
• Reopen RateExpresses the percentage of closed tickets that were later reopened.
• Average Resolution TimeAverages the number of days between a ticket being created and being closed.
• First Response TimeAverages the number of hours between a ticket being created and receiving its first reply.

More DAX resources

Browse all 175 measures in the Power BI DAX Measures Library, or search the library for something similar to Open Tickets, Closed Tickets.