Forum Discussion
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 understands what I want to calculate.
As always, thank you so much for all your help and support.
Best regards
Jose Luis
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
7 Replies
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!!Hi Naveen,
Thank you so much for responding so quickly.
I had already tried this function but it does not work for me.
Best regards
Please post a sample of data that would be involved in calculation and visual.
Hello
For confidentiality I can not reproduce the data of my client, but I can simulate them with another image that I attached. It is true that my previous explanation was not correct. Here I explain what I want.
Thank you very much again.
Best regards
Syndicate_Admin
It would be better if you could create a sample data similar to what you have and also provide a desired output. The above attached image is confusing.Regard,
Naveen
I agree. I prepare it and share it.
Thanks again.
Best regards
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
