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
ricardocamargos's avatar
ricardocamargos
Continued Contributor
8 years ago

Hi Anonymous,

 

Can you provide some data as sample, also show us your table structure ?

 

Ricardo

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous, ricardocamargos,

     

    Thank you for your responses.

     

    I am simply adding a column to the table, no measures involved.

     

    Please refer to the attachment. Observe that when I click on "SUM" instead of "Don't Summarize", the values change too.

     

    • ricardocamargos's avatar
      ricardocamargos
      Continued Contributor
      8 years ago

      Anonymous,

       

      Can you provide you table structure ?

       

      Also, are you creating a calculated column ? If yes, show us the code.

       

      Ricardo

      • 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.