Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

DEFECT with SUM Data

I have found a case where SUM is working incorrectly.

 

Example1.png

Then I change the field "Time Spent Hours" from "Don't summarize" to "Sum"

example2.png

Once this is switched to "Sum" the value changes from .50 to 11, which is impossible ot explain other than it is a defect.

 

example3.png

 

Please help me with a fix for this as it prevents me from using powerbi for my being useful for summarizing this field.

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @michael_mcclari

 

Is it possible for you to share the pbix file with us? If it is, please remove sensitive data in report, upload the file to your OneDrive and paste the share link here. 

 

Best Regards,

Qiuyun Yu