Forum Discussion

timmcn's avatar
timmcn
Regular Visitor
10 years ago

Incorrect report table column total

Hi,   Firstly, my apologies as I am new to Power BI Desktop and I'm sure this is something obvious.   When I create a report which includes our Weighted Refill Score measure, the total is far gre...
Need Help
jeffreykeryk's avatar
jeffreykeryk
Helper I
10 years ago

Here is an example: Create a pivot, and set summarization to Average. In my case, the table averages are fine, but the totals are whack. Here is Excel, with correct values (average of 3 values is 1,916,498:

2014 Q1
 
                    1,046,283
 
 
                    1,981,491
                    2,721,719
 
 
 
 
 
 
 
                   1,916,498

 

However, Power BI returns 1,932,746.

Please advise, as this is a deal killer for me.