Forum Discussion

Saloni_Gupta's avatar
Saloni_Gupta
Helper I
2 years ago
Solved

DIVIDE function not handling division by zero

Hi All, I have a simple dax calculation for Revenue and EM% as below: Revenue - FYTD = var temp = CALCULATE(SUM('FactMonthlyRevenueandBudget'[ActualsRevenue]),'Month Table'[YTD Flag] = "Y") RETU...
  • _AAndrade's avatar
    2 years ago

    It's seems it's not zero on that row but a small number. Try to use the round function to see if it's the real problem