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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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