Use division instead of DIVIDE

When the denominator is a non-zero constant, DIVIDE can be replaced with the native division operator.

Remarks

DIVIDE always forces the Formula Engine to evaluate the expression and, in many scenarios, this may results in poor Storage Engine cache usage and worse performance compared to a native division operator.

Recommended articles:

• DIVIDE Performance

Example 1

Replace DIVIDE with / division operator.

Original code

SUMX ( 
    Sales, 
    DIVIDE ( Sales[Quantity], 3 )
)

Possible optimization

SUMX ( 
    Sales, 
    Sales[Quantity] / 3
)