Count reset

Hi matus_jun ,

Based on the testing, try using the following DAX formula to create a new column.

CountByNewDayType = 
VAR CurrentEmployee = 'New day table'[employee_id]
VAR CurrentIndex = 'New day table'[Index]
VAR PreviousRows =
    FILTER(
        'New day table',
        'New day table'[employee_id] = CurrentEmployee &&
        'New day table'[Index] < CurrentIndex
    )
VAR PrevRowWithZero =
    MAXX(
        FILTER(
            PreviousRows,
            'New day table'[NewDayType] = 0
        ),
        'New day table'[Index]
    )
RETURN
IF(
    'New day table'[NewDayType] = 0,
    0,
    COUNTROWS(
        FILTER(
            PreviousRows,
            'New day table'[Index] > PrevRowWithZero
        )
    ) + 1
)

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.