Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Sum computed incorrectly

Hi PBI users,   I am adding a column name and cost to a table. As usual, cost is aggregated to sum which is displayed as 6000. But the actual sum is 1000. The table is not joined to any other table...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

ricardocamargos,

 

This is not a calculated column. 

 

Could this be due to the size of the table? When I reduced the size of the table to a couple of rows, instead of 1M rows, it calculates the Sum correctly.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

This has nothing to do with size.  Just create a meaure as follows:

 

=SUM(Data[Cost])

 

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Ashish_Mathur,

     

    I tried that as well, doesn't work.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      Share the link from where i can download your file (please ensure that the file siz is only a few KB's) and show the expected result there.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Ashish_Mathur

         

        As soon as I reduce the size of the file and recreate the table, it works fine.

         

        But that is not a solution to the problem. I need to have those 1M rows in my table.