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
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