Forum Discussion

ZalinaBaskaty's avatar
ZalinaBaskaty
Frequent Visitor
2 years ago
Solved

correct table rows but total needs help - SUMX maybe?

Here is my scenario: I have three separate orders shipped that day, each order has a different number of lines within it. Order #3276 has 3 lines, #3293 has 2 lines, #3319 has 3 lines. I calculated n...
  • elitesmitpatel's avatar
    2 years ago

    Hi ZalinaBaskaty 
    Try this 
    Total Lines Shipped =
    SUMX(
    VALUES('Orders'[OrderNumber]),
    [Lines Per Order]
    )