Accumulated Sla Breached

[xerikx]

Please could someone help me to elaborate the table to calculate the accumulated, I have no idea how I could do it or how to approach it

My Data

I want to make this table or graph

Month	Count Ticket SLA breached	I do not need this column, I am putting it so that you can understand the calculation
Ene-21	0	Id01 was created in January but breached SLA from February to July (expected resolution date to resolved date)
Feb-21	1	Because id01 breached sla until resolved date (25/07), id02 was created but it just broke in March
Mar-21	2	Because id01 breached sla until resolved date ( 25/07 ) and id02 breached sla until resolved date (20/05)
Abr-21	2	Because id01 breached sla until resolved date ( 25/07 ) and id02 breached sla until resolved date (20/05)
May-21	2	Because id01 breached sla until resolved date ( 25/07 ) and id02 breached sla until resolved date (20/05)
Jun-21	1	Because id01 breached sla until resolved date ( 25/07 )
Jul-21	1	Because id01 breached sla until resolved date ( 25/07 )
Ago-21	0

[lbendlin · Accepted solution]

Count Tickets SLA Breached = CALCULATE(COUNTROWS('Table'),'Table'[Resolved Date]>Min(Dates[Date]),'Table'[Created Date]<Max(Dates[Date])-25)

See attached. This also works on day level granularity.

[xerikx]

Excellent solution, another question how can i show the ID for each month?

Slicer Month: Selected Mar-21

Result Table:

Id	Created
id01	10/01/21
id02	11/02/21

[lbendlin]

Those data points do not depend on the slicer. Create a separate table visual that has only Id and Created columns.