IF filter value does not exist, then use other values

Hi elkjoperik,

There is a solution. Please refer to the file in the attachment. You need to rebuild the model. It's hard to filter the proper data in the model in which all the data is stored in one table. 

Solution =
VAR lastweekTotal =
    CALCULATE (
        SUM ( LW_DUMMY[Revenue FY] ),
        FILTER (
            ALL ( 'Calendar' ),
            'Calendar'[WeekNum]
                = MIN ( 'Calendar'[WeekNum] ) - 1
        )
    )
RETURN
    IF (
        ISBLANK ( lastweekTotal ),
        CALCULATE (
            SUM ( LW_DUMMY[Revenue FY] ),
            FILTER (
                ALL ( 'Calendar' ),
                'Calendar'[WeekNum]
                    = MIN ( 'Calendar'[WeekNum] ) - 1
            ),
            ALL ( Segments )
        ),
        lastweekTotal
    )

Best Regards,
Dale