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 number of lines using a variable. That part works as intended.
What do I do so that my total shows 8 lines shipped (with 3 associated orders) instead of 7? Thank you much!!!
Hi ZalinaBaskaty
Try this
Total Lines Shipped =
SUMX(
VALUES('Orders'[OrderNumber]),
[Lines Per Order]
)
3 Replies
- elitesmitpatel
Solution Supplier
Hi ZalinaBaskaty
Try this
Total Lines Shipped =
SUMX(
VALUES('Orders'[OrderNumber]),
[Lines Per Order]
) - ZalinaBaskatyFrequent Visitor
Worked like a charm! Thank you SO much!
- Greg_Deckler
Community Champion
ZalinaBaskaty Please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e