Forum Discussion
Solved
Add rows on an invoice
Good morning community, I've been thinking about a DAX function for a while now that adds all the lines of an invoice, but I can't quite get it. I put an example in an image, so that everyone un...
Hello @Syndicate_Admin ,
I finally solved it as follows:
SUMX(VALUES(TABLA[CANTIDAD]),
CALCULATE(MAX(TABLA[PAX])))Thank you very much for your invaluable collaboration!
Best regards
Hello Syndicate_Admin
Try the below Dax.
Total =
CALCULATE (
SUM ( 'Table'[Cantidad] ),
ALLEXCEPT ( 'Table', 'Table'[Factura] )
)
Let me know if this helps!
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!