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.

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