Add rows on an invoice

[Syndicate_Admin]

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

[Syndicate_Admin · Accepted solution]

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]

I agree. I prepare it and share it.

Thanks again.

Best regards

[Syndicate_Admin]

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

[NaveenGandhi]

@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

[Syndicate_Admin]

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

[NaveenGandhi]

Please post a sample of data that would be involved in calculation and visual.

[NaveenGandhi]

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