Resetting counter after conditions are met

[PomJack]

Hi Power BI community,

I am trying to count the number for events that different fixtures have over the life of the fixture as measured by date and number of hits on the fixture. When the fixture is worn out, it is repaired and the number of hits resets. I am currently using this function below to calcaulte the running count for each die. It works until the die hits is reset, and then it does not calculate the count as I would like. 

Event Count =

COUNTROWS(

    FILTER('Errors',

    'Errors'[Die] = EARLIER([Die]) &&

    'Errors'[Die Hits] <= EARLIER('Errors'[Die Hits]) &&

    'Errors'[Date] <= EARLIER('Errors'[Date])

    ))

Event	Die	Date	Die Hits	Event Count (Current)	Event Count (Ideal)
A	X	8/1/24	205	1	1
A	X	8/2/24	300	2	2
A	X	8/3/24	330	3	3
B	Y	8/3/24	1400	1	1
B	Y	8/4/24	1456	2	2
A	X	8/5/24	500	4	4
B	X	8/6/24	210	2	1
A	X	8/6/24	240	3	2
A	X	8/7/24	310	3	3

My second part to this question, is how would I go about displaying just information from the most recent reset for each fixture in report view. Ultimately, I want to display this information in a graph similar to the one below.

[lbendlin]

First part - DAX does not support conditional accumulations. The only tool I know of that can do that is Power Query's List.Accumulate.

Second part is actually easier. You can use a measure to identify the last reset point and then suppress everything before that point.