Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    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)

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

hi Anonymous  - What is the column formatted as in excel? also can you share the approx. number of records you have. 

As far as I am aware there is no issue with Totals in PowerBI - works fine in all visuals I have used so far. 

This could be a rounding issue in Excel though 175.44 to 181 seems a bit of a stretch but could happen if you have a large volume of data. 

 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!