Ticket Backlog (How many were open on specific dates)

Incident Backlog =

VAR CurrentDate = MAX('Date'[Date])

VAR ActiveTickets =

CALCULATE(DISTINCTCOUNT(Incidents[Number]),

ALL('Date'),

'Date'[Date]<=CurrentDate,

ISBLANK(Incidents[Resolved Date])

||Incidents[Resolved Date]>=CurrentDate)

Return

ActiveTickets