Forum Discussion
Helper IIncorrect calculated measure total
Ya, that won't math correctly. If math was a verb.
1 2
2 3
3 4
(1+2+3) * (2 + 3 + 4) = 6 * 9 = 54.
(1*2) + (2*3) + (3*4) = 2 + 6 + 12 = 20.
You want the latter, but are doing the fomer.
I would think...
Total Shipped Value = sumx(REV_HistoryReport, REV_HistoryReport[Total Li Valu Amt]) / REV_HistoryReport[Ord Bill Unit Qty] * OpenOrders[Qty Filled])
But... I'm skeptical that is going to handle OpenOrders correctly. How are those tables related?
Helper I- Kimbornhoft
Is there anything else you need to understand the relationships. Thanks for your help. I'm a novice at Power BI so your help is very much appreciated.
- Kimbornhoft
We thought it would work to create a relationship between the open orders and the Rev_HistoryReport based on the MMMID but we get this error message.