topic Ticket Backlog (How many were open on specific dates) in Quick Measures Gallery https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Ticket-Backlog-How-many-were-open-on-specific-dates/m-p/4794658#M1178 <DIV><DIV><SPAN>Incident Backlog =</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>CurrentDate</SPAN><SPAN> = </SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>'Date'</SPAN><SPAN>[Date]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>ActiveTickets</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>Incidents</SPAN><SPAN>[Number]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>'Date'</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>'Date'</SPAN><SPAN>[Date]</SPAN><SPAN>&lt;=</SPAN><SPAN>CurrentDate</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>Incidents</SPAN><SPAN>[Resolved Date]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>||</SPAN><SPAN>Incidents</SPAN><SPAN>[Resolved Date]</SPAN><SPAN>&gt;=</SPAN><SPAN>CurrentDate</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>Return</SPAN></DIV><DIV><SPAN>ActiveTickets</SPAN></DIV></DIV> Tue, 12 Aug 2025 14:50:27 GMT wardy912 2025-08-12T14:50:27Z Ticket Backlog (How many were open on specific dates) https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Ticket-Backlog-How-many-were-open-on-specific-dates/m-p/4794658#M1178 <DIV><DIV><SPAN>Incident Backlog =</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>CurrentDate</SPAN><SPAN> = </SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>'Date'</SPAN><SPAN>[Date]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>ActiveTickets</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>DISTINCTCOUNT</SPAN><SPAN>(</SPAN><SPAN>Incidents</SPAN><SPAN>[Number]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>'Date'</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>'Date'</SPAN><SPAN>[Date]</SPAN><SPAN>&lt;=</SPAN><SPAN>CurrentDate</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>Incidents</SPAN><SPAN>[Resolved Date]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>||</SPAN><SPAN>Incidents</SPAN><SPAN>[Resolved Date]</SPAN><SPAN>&gt;=</SPAN><SPAN>CurrentDate</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>Return</SPAN></DIV><DIV><SPAN>ActiveTickets</SPAN></DIV></DIV> Tue, 12 Aug 2025 14:50:27 GMT https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Ticket-Backlog-How-many-were-open-on-specific-dates/m-p/4794658#M1178 wardy912 2025-08-12T14:50:27Z