Forum Discussion

ZachRoberts's avatar
ZachRoberts
Frequent Visitor
5 years ago
Solved

Table not calculating sum correctly

Hello,   I have the below data and for some reason when I set the value of my Hours field below to Sum of Hours it doubles the data instead of giving a correct sum.   Worker Hours Date W ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi ZachRoberts ,

     

    One reason is that there are duplicate identical rows. It will not display duplicate rows in Power BI. Please check whether there are duplicate rows in your data source table.

     

    The solution is to add an index column.

     

    Best Regards,

    Stephen Tao

     

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi ZachRoberts ,

 

One reason is that there are duplicate identical rows. It will not display duplicate rows in Power BI. Please check whether there are duplicate rows in your data source table.

 

The solution is to add an index column.

 

Best Regards,

Stephen Tao

 

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

ZachRoberts's avatar
ZachRoberts
Frequent Visitor
5 years ago

Yea there does appear to be duplicate entries in our data - started with just my table of the hours and worked through it there to find the issue. Will work to fix why we have duplicate entries now haha 

 

Thanks everyone for your help