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

ZachRoberts's avatar
ZachRoberts
Frequent Visitor
5 years ago

HashamNiaz ,

 

Thanks for the reply - Please see the below screenshots of the relationship

 

 

Thanks,

Zach 

HashamNiaz's avatar
HashamNiaz
Solution Sage
5 years ago

Hi ZachRoberts !

 

Please check by placing columns only from [JCT] table into table / matrix visual if you are able to get correct result for particular day.

 

Regards,

Hasham

  • ZachRoberts's avatar
    ZachRoberts
    Frequent Visitor
    5 years ago

    Please see the screenshot below - all fields are from the JCT table 

     

    Is it an issue with the values and how they related to the date fields? Would still expect the hours to be able to sum for the correct value though

     

    Thank you

    • HashamNiaz's avatar
      HashamNiaz
      Solution Sage
      5 years ago

      Hi ZachRoberts !

       

      Try to remove Consumption Date from visual. Also please share sample file as some relationship is causing the duplicates to be reurned.

       

      Regards,

      Hasham