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.
