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
