title: PowerBI Percent Average Different Than Excel Average
body: <p>I'm moving from an old Excel based reporting system to PowerBI and I'm finding some discrepancies.</p>
  
  <p>When I take the same listed percentages in PowerBI and calculate the average in excel, it's different (See Below):</p>
  
  <p>I have no idea what's going on here... I thought maybe it was a rounding issue, but it's just not making sense to me.</p>
  
  <p>When I export the PowerBI data from the table and then average it in excel it's a different number. </p>
  
  <p>That shouldn't happen, right?</p>
  
  <p>Am I going crazy here?</p>
  
  <p><a href="https://i.stack.imgur.com/t585T.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/t585T.png" alt="ExcelWTF"></a></p>
  
  <p><a href="https://i.stack.imgur.com/Go0ih.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Go0ih.png" alt="PowerBIWTF"></a></p>
  
  <p>When I calculate it manually I get <code>99.828%</code> which should round to <code>99.83%</code> as Excel shows.</p>
  
  <p>It seems to me that the PowerBI average is simply incorrect.</p>
  
  <p><strong>Edit:</strong></p>
  
  <p>After applying RADO's answer, here are my results (I dropped the Round and it seems to work - I think maybe it's an issue with my data - not his methodology):</p>
  
  <p><a href="https://i.stack.imgur.com/CC6uO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CC6uO.png" alt="Yay"></a></p>