title: Why doesn't the grand total in this power pivot table sum all columns correctly?
body: <p>For some reason, the grand total here does not sum both columns. Any idea what could be the problem here? </p>
  
  <p><img src="https://i.ibb.co/Sf4WP4M/pivot-table-final.png"></p>
  
  <p><img src="https://i.ibb.co/P1zQqMF/pivot-table-2.png"></p>
  
  <p>This was created via a tabular project / model in Visual Studio.</p>
  
  <p>I have no idea how to tackle this problem (our guy who did BI left the company and now I have to pick up the tab and I'm new to this world).</p>
  
  <p>I don't know if it's a model problem or if there is some configuration I need to change for the pivot table so that it sums things properly. Anyone have any idea? Thanks.</p>
  
  <p>Here's the related measures:</p>
  
  <pre><code>Combined Sum Amount QTD:=[Rev Exp Sum Amount QTD] + [HV Sum Amount QTD]
  
  Rev Exp Sum Amount QTD:=IF(HASONEVALUE(Calendar[Period Ending]),
  CALCULATE([Rev Exp Sum Amount ITD], LASTDATE(Calendar[Date]))-OPENINGBALANCEQUARTER([Rev Exp Sum Amount ITD],Calendar[Date]),BLANK())
  
  HV Sum Amount QTD:=IF(HASONEVALUE(Calendar[Period Ending]),
  CALCULATE([HV Sum Amount ITD], LASTDATE(Calendar[Date]))-OPENINGBALANCEQUARTER([HV Sum Amount ITD],Calendar[Date]),BLANK())
  </code></pre>