Sum Lines of Distinct Order Number

[smireles]

Hello,

This is probably a very easy calculation but I cant seem to get it to work.

I am trying to sum the lines of distinct order number.

So it should be 

Order Number = 2 

Lines = 15

Thanks!

[Nathaniel_C · Accepted solution]

Hi @smireles , try this:

Sum of orders = CALCULATE(Sum(Table [Lines]),ALLEXCEPT(Table ,Table [Order Number]))

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel