Additive, Non-Additive Column Totals - WTH

I'm aware of the additive/non-additive column total issue in Desktop - really wish MS would do something about this already. I'm creating a simple table (also tried a matrix with same results) that will eventually have 3 columns - Total Current Inventory Value, Local Rebate Rebate Percent, and Deferred Rebate dollar value.   For now, let's focus on just the TCIV column. TCIV is defined as On Hand Value + On Order Value. Each of these is a non-calculated column in my Inventory table coming from the DB. I've tried creating simple measures to calculate TCIV as well as creating a calculated column to do the same thing. Both procedures produce the wrong column totals in the table. 

TCIV Measure uses this:
TotalOnHandValue = SUM('Inventory Snapshot'[OHV])

TCIVMeasure = [TotalOHV] + [TotalOOV]

TCIV Calculated Column uses this:

TCIVCalcColumn = [On Hand Value] + [On Order Value]

Here's what the TCIV *should* be (from Excel) for both procedures:

And here's what the table totals are in BI Desktop:

As you can see, there's a substantial difference between the two totals, over 2 millions dollars. I'd read that using a calculated column can sometimes work around this issue, but that's not the case here. I've also tried using the SUMX(VALUES...... method, but the results still come out wrong. Any suggestions for getting the correct totals in Desktop?