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],[Sales])
Need Help
Show and Tell
Tips and Tricks

6 Replies

  • 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.