Forum Discussion

River's avatar
River
Icon for Helper IV rankHelper IV
6 years ago
Solved

Total not adding up in table visual

Hi Friends,   We are getting weird problem, "total" displayed in table is missing amount for one row, Please see screen shot, I narrowed it down to these two customers. It doesn't happened to any o...
Need Help
  • River's avatar
    River
    6 years ago

    We figured out the problem is caused by data irregularity, data model can't handle the case.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi River 

I build a table like yours to have a test.

Table:

And I build a table visual, my result of total is right.

Here I have some advice for you.

Please check the version of your Power BI Desktop, if it is not the latest one please upgrad it by this link: Upgrad

 

If this reply still couldn’t help you to solve this problem, please tell me whether three columns come from the same table or not, and please download and use my pbix file to have a test ,or you may share your pbix file with me from your Onedrive for business.

You can download the pbix file from this link: Total not adding up in table visual

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

River's avatar
River
Icon for Helper IV rankHelper IV
6 years ago

Thanks Rico, I have latest version.

 

And those columns are from different tables, those 3 records are only ones not adding to total out of 100 of thousands records.

 

How can I upload my pbix?

 

River

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago

    Hi River ,

     

    You can upload the files by onedrive, google drive, wetransfer or similar links.

    • River's avatar
      River
      Icon for Helper IV rankHelper IV
      6 years ago

      We figured out the problem is caused by data irregularity, data model can't handle the case.