DIVIDE Function (DAX)

🎯Purpose

Safe division function in DAX that automatically handles division by zero, returning blank or an alternate result instead of #ERROR.

Syntax

DAX

DIVIDE(<numerator>, <denominator>, [<alternate_result>])

DAX

Resolution_Rate := DIVIDE(
    [Resolved_Calls],
    [Answered_Calls],
    0
)