Forum Discussion

Digger's avatar
Digger
Post Patron
4 years ago

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]...
Need Help
Show and Tell
Tips and Tricks
bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

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's avatar
    Digger
    Post Patron
    4 years ago

    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's avatar
      bcdobbs
      Community Champion
      4 years ago

      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's avatar
        Digger
        Post Patron
        4 years ago

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