Calculate a previous level missing

Hi RsimonAlign 

Try this code to add a new table:

New Table = 
VAR _A =
    SUMMARIZE ( 'Table', 'Table'[Region], 'Table'[Country], 'Table'[Week] )
VAR _B =
    VALUES ( 'Table'[Product] )
VAR _C =
    CROSSJOIN ( _A, _B )
RETURN
    ADDCOLUMNS (
        _C,
        "Quantity",
            IF (
                CALCULATE (
                    MAX ( 'Table'[Quantity] ),
                    FILTER (
                        ALL ( 'Table' ),
                        'Table'[Country] = EARLIER ( [Country] )
                            && 'Table'[Week] = EARLIER ( [Week] )
                            && 'Table'[Product] = EARLIER ( [Product] )
                    )
                )
                    <> BLANK (),
                CALCULATE (
                    MAX ( 'Table'[Quantity] ),
                    FILTER (
                        ALL ( 'Table' ),
                        'Table'[Country] = EARLIER ( [Country] )
                            && 'Table'[Week] = EARLIER ( [Week] )
                            && 'Table'[Product] = EARLIER ( [Product] )
                    )
                ),
                CALCULATE (
                    SUM ( 'Table'[Quantity] ),
                    FILTER (
                        ALL ( 'Table' ),
                        'Table'[Week] = EARLIER ( [Week] )
                            && 'Table'[Product] = EARLIER ( [Product] )
                    )
                )
            )
    )

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/