Count everytime a status change

stefanycheck

Try this calculated column

EarliestIndex =
VAR Temp =
    CALCULATE (
        MAX ( [Index] ),
        FILTER (
            Table1,
            [Index] < EARLIER ( [Index] )
                && [STATUS] <> EARLIER ( [STATUS] )
        )
    )
VAR Temp1 =
    CALCULATE (
        MIN ( [Index] ),
        FILTER (
            Table1,
            [Index] > EARLIER ( [Index] )
                && [STATUS] <> EARLIER ( [STATUS] )
        )
    )
RETURN
    IF ( [Index] > temp && OR ( [Index] < temp1, ISBLANK ( temp1 ) ), temp + 1, 0 )

Then put the distinct count of this column along with the STATUS in a TABLE visual