Confusing rounding issue

[PVO3]

Hello,

I have a very silly issue, which is problably very easily resolved.

In the dataview I have a single table with 2 identical columns. Both with the same input, data type [Decimal number], Format [Currency], Decimals [2], Summarization [Sum].

For both I created a SUM(Column) measure. These measures also have the same properties as the columns.

Still, 1 of them is showing the expected result, where the other seems to round some way or the other. Because of the large dataset, the difference adds up quickly. If I refer to the other column within the measure, the problem remains. So measure doesnt seem to be the problem.

To be honest I have no clue how this is possible. Anyone has I clue what I'm missing?

[vanessafvg]

if you change it to fixed decimal type does it make a difference?  its hard  to identify the issue without the data.  Never experienced this issues before - if you tried to aggregated a different way, if you did a group by in power query and sum it that way does it have the same issue?

[PVO3 · Accepted solution]

Hi @vanessafvg , 

Seems like that a system reboot did the trick. Should have tried that before posting. Still, I cant explain it.

Thanks for replying anyway!