Consecutive Days With Status Changes

Hi,

Please check the below picture and the attached pbix file.

It is for creating a calcualed measure.

It might be different if the source becomes mroe complicated, however, based on what I got from the sample, the below is one of many ways to achieve the solution.

Expected result measure: =
IF (
    HASONEVALUE ( Data[ID] ),
    CALCULATE (
        COUNTROWS ( Data ),
        WINDOW (
            1,
            ABS,
            0,
            REL,
            SUMMARIZE ( ALL ( Data ), Data[ID], Data[Date], Data[STATUS] ),
            ORDERBY ( Data[Date], ASC ),
            KEEP,
            PARTITIONBY ( Data[ID], Data[STATUS] )
        )
    )
)