Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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/
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |