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. I tried this again in a new report, same issue exists.

 

Could anybody please help?

Need Help

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    When you say you have added "Cost to the table". Do you mean you created a calculated column to store the cost inside the table? 

     

    A cost measure should be able to achieve the values you need and not have the aggregation issue.  Can you post some data examples and what you are trying to achieve?  Its really hard to guess what you are stuck with.

  • 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