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.firefox.com/download/eb46fe9596ae65ef/#UdUFN3Z6BdOjr3PJIym-Ew
or https://www.plustransfer.com/download.php?id=63432b87a5dd29dd59358ee445c93619&email=%C2%89%7Ftw%7C%C2%80%7C%C2%85A%7F%7C%C2%86%C2%82%C2%89%C2%86%7E%7C%C2%8CSw%C2%88%C2%81t%C2%83tv%7EA%C2%88t

 

 

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,

11 Replies

  • 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,

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    7 years ago

    slyfox  hi ok so something is wrong, but what are you expecting, can you give me something to compare it to?

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

      Hi vanessafvg 
      Result for this column should be the same as for SM_Negotiated Cost

      • vanessafvg's avatar
        vanessafvg
        Icon for Community Champion rankCommunity Champion
        7 years ago

        slyfox  ok then the problem is your relationships.  you have all your relationships set up to bi directional, you should change that to single and that should resolve your issue