topic Re: Incorrect measure totals in DAX Commands and Tips

Incorrect measure totals

Novembur — Wed, 22 Dec 2021 14:14:30 GMT

Hello, I have two tables I'm using in this visual. [Alt_Prices] & [Order status]

Alt_Prices only has: Alt_Price_2 in this visual

Order Status has: Qty_Ordered & Description

I'd like to omit all of these and replace them with the measure Alt_Price_2 x Qty_Ordered. All I need is the total value, not a breakdown of where the values came from. However, it seems to be taking the total quantity summed up & multiplying that value by the alternate price rather than multiplying by the values directly.

I'd ideally like the value showing "$2,280.00" to show "$240.00" instead. I've tried some variations of SUMX but I seem to be missing the insight on how to use it properly (if that is even the best method). Any ideas on how best to get the correct total? Any help would be greatly appreciated, thanks!

Re: Incorrect measure totals

Syk — Wed, 22 Dec 2021 14:51:17 GMT

Check out this video: https://youtu.be/Rii_6qkLNh8
It helped me when I ran into the exact same issue!

Re: Incorrect measure totals

AlexisOlson — Wed, 22 Dec 2021 17:57:56 GMT

Does this work for you?

SUMX ( Table1, Table1[QTY_ORDERED] * Table1[ALT_PRICE_2] )

Re: Incorrect measure totals

Novembur — Wed, 22 Dec 2021 19:25:05 GMT

Thanks, this video was very insightful and helpful. The suggestion someone else posted worked so I didn't try this myself but helped me understand the relationships better.

Re: Incorrect measure totals

Novembur — Wed, 22 Dec 2021 19:29:08 GMT

Yes, this was exactly what I needed thank you. Will use this logic to help solve my other similar issues on this project. 🙂

My only note for future users who make look at this post. In the example above [alt price] would be table 2, not 1 for this sequence.