cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
wbhite Frequent Visitor
Frequent Visitor

Need help understanding how this total is being calculated

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.

 

 

NetMarginCalcIssue.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Need help understanding how this total is being calculated

@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/

1 REPLY 1
Super User
Super User

Re: Need help understanding how this total is being calculated

@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/