Incorrect measure totals

[Novembur]

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!

[AlexisOlson · Accepted solution]

Does this work for you?

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

[Novembur]

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.

[Syk]

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

[Novembur]

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.