Need help understanding how this total is being calculated

[wbhite]

Hello, all.  I'm having an issue figuring out how PBI is determining a Total of -37% in the table below.  The individual records don't add or average to that number, so it's not making any sense to me.  Any thoughts on some obvious things to look for?  Thanks.

[Zubair_Muhammad · Accepted solution]

@wbhite

I believe Net Margin% would be a MEASURE

something like

Net Margin%=Net Income / Revenue

At the total level,, it would be taking the Net Income of all the Accounts divided by Revenue of all the accounts

This is a small post which might be relevant to you

http://www.excelnaccess.com/incorrect-total-for-a-measure/