Forum Discussion
Avg Total
Hello - I have the average of opportunties (from our sales team) in a table visual. The total (presumably the average) shows 175.44 but if I export the table to Excel, the average shown in Exce...
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)
Hi,
Share the Excel file and show the discrepancy there very clearly. Also, share the PBI file.