Incorrect total in Power BI

[Chukliz]

Hi All,

Please could you help with this? I created a visual in Power Bi but the Total is wrong compare when you add it up manually. Please help! See table below

In Power BI
Service area length total
Complaint 105
Development 2370
Finance 818
Housing 3322
Property Services 3638
Total in Power BI 3760

Service area length total
Complaint 105
Development 2370
Finance 818
Housing 3322
Property Services 3638
Manually calculated total 10253

[BrianJ]

@Chukliz,

The incorrect totals problem is a very common one in Power BI. Please check out the thread below, which includes two videos from @sam.mckay explaining how to fix this problem:

Power bi divide formula is averaging out the result instead of Sum

Hello Everyone, Good Day! I have a table as per the attached image where for price column i need to get sum, but instead it’s averaging out in power bi. Pbix file is attached for your reference. Any help is much appreciated on this. Thanks, Niraj [power%20bi1] [power%20bi2] Test.pbix (39.2 KB)

If you still have problems after taking a look, please just post your PBIX file and we can work through the specific solution for your data.

I hope this is helpful.

• Brian

P.S. here’s another thread that provides more explanation as to why the incorrect total/subtotal problem occurs, with an additional useful video link on evaluation context:

Incorrect column totals in final results

@BrianJ, Here are the results from my dummy data. As you can see, my totals randomly get me correct and incorrect answers. I am very interested in solving this using variables (VAR) formulas. However using HASONEVALUE to change from row context to context is also going to be useful for my future development. I appreciate your help. [image] New Originations.xlsx (2.3 MB) New Originations.pbix (220.3 KB) Ben