Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
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...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    3 years ago

    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

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

I agree. I prepare it and share it.

Thanks again.

Best regards