Error on simple subtract measure

[AGo]

As you can see the last measure that which should be 0.00 results 7.11E-15.

This measure performs a simple subtraction [measure1]-[measure2] and all the measure in my report are formatted with 2 decimal numbers. The datasource contains only multiple numbers of 0.25.

The other problem is that under the yellow bar I can see 0.00, but there should be another equal one under this, and so also under the orange one.

[PavelR]

I would try to check underlying data for these categories, where are weird numbers in result. Maybe you will see, that you have some atypical data (values)...

Regards.

Pavel

[AGo]

The datasource contains only typical values: multiple numbers of 0.25.

[PavelR]

I would definitely check underlying data and if everything is OK, then I would check meaning/syntax of your formulas.

There have to be some "bug".

Regards.

Pavel

[v-haibl-msft]

@AGo

It is better to provide your source data and measure formulas, or you can provide your PBIX file directly (You can upload the file to online file service like OneDrive and share it). I’d like to try to repro it locally.

Best Regards,

Herbert