Random number in Decimals showing in when it should be zero in table visuals

[kritchensBMcD]

Hi all, have a weird issue with powerbi. When loading data in and showing up in the table area the number looks fine. But when we add the number to a table visual it shows a random 1 when there should be all zeros. Has anyone run into this issue before?

[v-chuncz-msft · Accepted solution]

@kritchensBMcD 

You might need to check the aggregation.

https://docs.microsoft.com/en-us/power-bi/service-aggregates#change-how-a-numeric-field-is-aggregate...