March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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
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
I agree. I prepare it and share it.
Thanks again.
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
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 @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!!
User | Count |
---|---|
122 | |
99 | |
89 | |
74 | |
66 |
User | Count |
---|---|
138 | |
115 | |
115 | |
98 | |
98 |