Forum Discussion
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 ...
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
Hi,
Drag Worker to the Table visual and write this measure
Hours worked = sum(Data[Hours])
Hope this helps.
Ashish_Mathur thank you for the reply but that didn't work for me still got the doubled value
Hi,
Share the link from where i can download your PBI file.