Forum Discussion
ZalinaBaskaty
2 years agoFrequent Visitor
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...
- 2 years ago
Hi ZalinaBaskaty
Try this
Total Lines Shipped =
SUMX(
VALUES('Orders'[OrderNumber]),
[Lines Per Order]
)
elitesmitpatel
2 years agoSolution Supplier
Hi ZalinaBaskaty
Try this
Total Lines Shipped =
SUMX(
VALUES('Orders'[OrderNumber]),
[Lines Per Order]
)