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)

     

     

VijayP's avatar
VijayP
Community Champion
5 years ago

Anonymous 

It is Rounding issue. In Power BI Table increase the Decimals and then download to excel and let me know whether this issue resolved.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

VijayP    Ashish_Mathur    Anonymous 

 

I do not think it is a rounding issue.   If I constrain the date range so just three records show, you can use a calculator to find the average of these three values would be 177.66.     But the table in Power Bi shows 165.76  using the formula below. 

 

Avg Opp Age = AVERAGEX('AllOpps-Products','AllOpps-Products'[Days Since Sales Opp. Created])

 

Ideally, not only should the total average be correct, it should be dynamic and adjust as the number of records does.