Do a select * for certain cases in DAX query

Hi IcingOnTheCake 

Maybe

EVALUATE
FILTER (
    SUMMARIZECOLUMNS (
        'Customer Sell-To'[Sell-To Customer],
        'Date'[Calendar Year],
        'Date'[Calendar Quarter],
        'Date'[Month],
        'Product'[Product Hierarchy Level 1],
        'Product'[Product Hierarchy Level 2],
        'Product'[Product],
        FILTER (
            VALUES ( 'Customer Sell-To'[Sell-To Customer Code] ),
            'Customer Sell-To'[Sell-To Customer Code] = @P_Customer
        ),
        FILTER (
            VALUES ( 'Product'[Product Hierarchy Level 1 Code] ),
            PATHCONTAINS ( @P_PL1, 'Product'[Product Hierarchy Level 1 Code] )
        ),
        FILTER (
            VALUES ( 'Product'[Product Hierarchy Level 2 Code] ),
            IF (
                NOT ( ISBLANK ( TRIM ( @P_PL2 ) ) ),
                PATHCONTAINS ( @P_PL2, 'Product'[Product Hierarchy Level 2 Code] ),
                TRUE
            )
        ),
        "Sales Amt EUR CY",
            CALCULATE (
                [Sales Amt EUR],
                FILTER (
                    VALUES ( 'Date'[Calendar Year] ),
                    'Date'[Calendar Year] = VALUE ( @P_CY )
                )
            ),
        "Qty CY",
            CALCULATE (
                [Quantity],
                FILTER (
                    VALUES ( 'Date'[Calendar Year] ),
                    'Date'[Calendar Year] = VALUE ( @P_CY )
                )
            )
    ),
    [Sales Amt EUR CY] <> 0
        || [Qty CY] <> 0
)

or

EVALUATE
FILTER (
    SUMMARIZECOLUMNS (
        'Customer Sell-To'[Sell-To Customer],
        'Date'[Calendar Year],
        'Date'[Calendar Quarter],
        'Date'[Month],
        'Product'[Product Hierarchy Level 1],
        'Product'[Product Hierarchy Level 2],
        'Product'[Product],
        FILTER (
            VALUES ( 'Customer Sell-To'[Sell-To Customer Code] ),
            'Customer Sell-To'[Sell-To Customer Code] = @P_Customer
        ),
        FILTER (
            VALUES ( 'Product'[Product Hierarchy Level 1 Code] ),
            PATHCONTAINS ( @P_PL1, 'Product'[Product Hierarchy Level 1 Code] )
        ),
        FILTER (
            VALUES ( 'Product'[Product Hierarchy Level 2 Code] ),
            OR (
                NOT ( ISBLANK ( TRIM ( @P_PL2 ) ) )
                    && PATHCONTAINS ( @P_PL2, 'Product'[Product Hierarchy Level 2 Code] ),
                ISBLANK ( TRIM ( @P_PL2 ) )
            )
        ),
        "Sales Amt EUR CY",
            CALCULATE (
                [Sales Amt EUR],
                FILTER (
                    VALUES ( 'Date'[Calendar Year] ),
                    'Date'[Calendar Year] = VALUE ( @P_CY )
                )
            ),
        "Qty CY",
            CALCULATE (
                [Quantity],
                FILTER (
                    VALUES ( 'Date'[Calendar Year] ),
                    'Date'[Calendar Year] = VALUE ( @P_CY )
                )
            )
    ),
    [Sales Amt EUR CY] <> 0
        || [Qty CY] <> 0
)