Forum Discussion
Avg Total
Anonymous
If the total average isn't correct, it probably has to do with the filter context of the table/matrix and how the relationships are established in the model, and/or the measures involved.
So we need more information about the model, how the table/matrix is set up and any measures involved.
(You will probably solve this by using an AVERAGEX(SUMMARIZE...) but it may be overkill depending on the model structure and matrix filter context)
Ok, so discovered the "why", but not sure of the fix.
The totals below will average on a calculator, or Excel, to 714.20 - just as they do here.
What made the difference was by adding "item" to the table. For example, the first two lines below are from the same Opportunity (from our CRM system)....but there are two distinct rows to this Opportunity, representing two differnent products that are part of the overall opportunity. So....adding the "item" (product) to the table exposed this additional row, and made the average total add up correctly. It was actually correct all along....just deceiving because the other rows were not showing. And when exporting to Excel, the export only captured the rows that were showing.
Sorry, I should have edited this to say that no "fix" is really needed at this point.
But your insight into the table and filter context is what led me to see what the issue was. Thank you