Forum Discussion
BUG dividing
How stupid PBI can produce this result? Sales = SUM(debsum) - SUM(CredSum) _F 11 EBITDA = m1 + m2 - m3 // does not matter, take for example 1 _MF 11 EBITDA = DIVIDE([_F 11 EBITDA]...
Ok!
Chsnge the data type of your Sales measure and the underlying columns to currency. I think you're getting issues from floating point arithmetic.
Sorry slight update to the above now I'm at a computer.
Set the data type for columns and measure to fixed decimal:
Data types in Power BI Desktop - Power BI | Microsoft Docs
Rather than decimal number.