Create a transitioning table between two selected dates

Hi MattJacob ,

I suggest you to create unrelated dimtables to help your calculation.

The relationship between these tables are all inactive.

Measure:

Count =
VAR _GEN1 =
    GENERATE ( 'Status(Row）', 'Status(Column)' )
VAR _GEN2 =
    GENERATE ( _GEN1, VALUES ( 'Table'[Case ID] ) )
VAR _SELECT1 =
    SELECTEDVALUE ( DimDate1[Date] )
VAR _SELECT2 =
    SELECTEDVALUE ( DimDate2[Date] )
VAR _ADDFlag =
    ADDCOLUMNS (
        _GEN2,
        "Flag",
            VAR _1 =
                CALCULATE (
                    MAX ( 'Table'[Status] ),
                    FILTER (
                        'Table',
                        'Table'[Case ID] = EARLIER ( [Case ID] )
                            && 'Table'[Date] = _SELECT1
                    )
                )
            VAR _2 =
                CALCULATE (
                    MAX ( 'Table'[Status] ),
                    FILTER (
                        'Table',
                        'Table'[Case ID] = EARLIER ( [Case ID] )
                            && 'Table'[Date] = _SELECT2
                    )
                )
            RETURN
                IF ( [Status(Row)] = _1 && [Status(Column)] = _2, 1, 0 )
    )
VAR _FILTER =
    FILTER ( _ADDFlag, [Flag] = 1 )
VAR _SUMX =
    ADDCOLUMNS (
        _GEN1,
        "Sumx",
            SUMX (
                FILTER (
                    _FILTER,
                    [Status(Row)] = EARLIER ( [Status(Row)] )
                        && [Status(Column)] = EARLIER ( [Status(Column)] )
                ),
                [Flag]
            )
    )
RETURN
    SUMX ( _SUMX, [Sumx] )

Result is as below.

Best Regards,
Rico Zhou

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