topic DAX formula doesn't sum correctly in DAX Commands and Tips

DAX formula doesn't sum correctly

Matt78 — Thu, 18 Apr 2024 05:41:40 GMT

Hi all,

I have been trying to figure out what I am doing wrong in this DAX formula. I have a normal sales table where I have cost, quantity and sales. Sales = qty x cost but now the following formula calculates the yellow ones and not the greeen ones I would like to sum. What can be seen in the screen shot, the price can change and the correct total sales here would be 229 710€

This is my current formula, any help how to fix this would be great. Thank you.

Sales € = SUMX(VALUES('Value Entries'), [Qty x Purch Price])

Matt

Re: DAX formula doesn't sum correctly

tamerj1 — Thu, 18 Apr 2024 06:25:43 GMT

HI Matt78
Please try

Sales € = SUMX ( SUMMARIZE ( 'Value Entries', 'Value Entries'[Item No], 'Value Entries'[Document No] ), [Qty x Purch Price] )

Re: DAX formula doesn't sum correctly

Matt78 — Thu, 18 Apr 2024 06:40:19 GMT

Hi,

Thank you for the quick reply, it works perfectly 🙂

Matti