Forum Discussion

Etienne_1995's avatar
Etienne_1995
Frequent Visitor
2 years ago
Solved

calculate correct sum with duplicates

  Hi   I am trying to solve the problem in a DAX-measure, that I get the correct sum of the delivered amount. I have duplicates within the column delivery number, because of additional data...
Need Help
  • zenisekd's avatar
    zenisekd
    2 years ago

     

     Kudos and mark as solution appreciated 🙂
Etienne_1995's avatar
Etienne_1995
Frequent Visitor
2 years ago

Hi zenisekd

 

I updated the screenshot.

So i would like to only sum up the delivery amount per distinct delivery nr.
Here for example. the supplier delivered the amount of 843 with the delivery number 45.
When I sum it up I don't want to have 843 twice. The same with the delivery nr 46. Does that help you to be able to answer my question?

  • zenisekd's avatar
    zenisekd
    Icon for Super User rankSuper User
    2 years ago

     

     Kudos and mark as solution appreciated 🙂
    • kymramosrpo's avatar
      kymramosrpo
      Icon for Advocate V rankAdvocate V
      2 years ago
      Simple, elegant, yet effective. Thank you!