Column Total does not match - Part 2

Hi Anonymous 

The change of the sum format in "Order Qty-adj" will change the row number and some variable of the table visual.

This is correlative to the context DAX:

Context in DAX Formulas - Microsoft Support

Please try this:

MEASURE =
VAR _vtable =
    SUMMARIZE (
        ALLSELECTED ( 'me2l' ),
        'me2l'[Material],
        'me2l'[Short Text],
        "_UP Per LY", [Unit Price per LY],
        "_UP per CY", [Unit Price per CY],
        "_Order Qty-adj", SUM ( 'me2l'[Order Qty-adj] ),
        "_PPV Total", [PPV Total]
    )
RETURN
    IF (
        HASONEVALUE ( 'me2l'[Material] ),
        SUMX (
            FILTER (
                _vtable,
                [Material] = SELECTEDVALUE ( 'me2l'[Material] )
                    && [Short Text] = SELECTEDVALUE ( 'me2l'[Short Text] )
            ),
            [__PPV Total]
        ),
        SUMX ( _vtable, [__PPV Total] )
    )

Best Regards

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