title: Power BI Table Column not working correctly
body: <p>I have the following DAX query that calculates the difference between TokenMinutes and BaselineUsage.  It works. See image below.</p>
  
  <p>However, when viewing the output in Table format, the Excess Total is incorrect.  Any ideas why? BTW... when I export the data and open in Excel, the column sum is correct.  It appears that only in Power BI does the total not match up.</p>
  
  <pre><code>ExcessUsage = 
      IF
      (
          (MAX(Vtatistics[TokenMinutes]) - (Reporting[Ad-HocUsage] + Reporting[BaselineUsage]) &lt; 0),
          (CALCULATE
              (
                  MAX(Statistics[TokenMinutes]) - (Reporting[Ad-HocUsage] + Reporting[BaselineUsage])
              )*-1),
      BLANK()
      )
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/LdbQ8.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LdbQ8.jpg" alt="enter image description here"></a></p>