Forum Discussion

slyfox's avatar
slyfox
Icon for Helper II rankHelper II
7 years ago
Solved

wrong column sum for allexcept measure

Dear Community,   Please help to solve an issue with Column SUM for ALLEXCEPT related measure. Report return expected row results, but sum for this row definitely wrong.   PBI file https://send....
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi slyfox 

    I would suggest you create a measure to get the correct total.

    Measure =
SUMX (
    SUMMARIZE (
        F_Shipment_Delivery,
        F_Shipment[SMP_Id],
        F_Shipment_Delivery[LINK_Delivery_Order]
    ),
    [Distr_NegoCost]
)

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi slyfox 

I would suggest you create a measure to get the correct total.

Measure =
SUMX (
    SUMMARIZE (
        F_Shipment_Delivery,
        F_Shipment[SMP_Id],
        F_Shipment_Delivery[LINK_Delivery_Order]
    ),
    [Distr_NegoCost]
)

Regards,