BUG dividing

[Digger]

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],[Sales])

[bcdobbs]

The problem comes from the total of the sales measure.

It's calculating as a tiny value eg 0.00000000000000001 You're then dividing by this and giving the large percentage.

How would you expect the sales measure to agregate at the total level? If it's a straight sum of each day you need to do:

Sales = 
SUMX(
   VALUES ( Date[Date] ),
   SUM(debsum) - SUM(CredSum)
)

[Digger]

@bcdobbs  i also thought like that, but i did a test,
Measure = [Sales] > 0  Result: False

Measure = [Sales] < 0  Result: True

Measure = [Sales] <-0.000000000000001  Result: True

[bcdobbs]

What value would you expect the total sales to be and how should it be aggregated?

_F 11 EBITDA Is also negative so I think your test further agrees with result you're seeing.

[Digger]

@bcdobbs  it should be empty, so only one working way is Round([Sales],2)

[bcdobbs]

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.

[bcdobbs]

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.