Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Column Total does not match - Part 2

Hi, This is Part 2 or continuation of my first inquiry on 'Column total does not match' See screenshot below:   The screenshot here pertains to Purchase Price Variance showing: 1.  Materia...
"Calculated Column"
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.