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]
)
ZalinaBaskaty
2 years agoFrequent Visitor
Worked like a charm! Thank you SO much!
Greg_Deckler
Community Champion
2 years agoZalinaBaskaty Please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e