Avoiding 'Infinity' and 'NaN' Results in PBI Calculation

[tedbuny]

We use a live connection for PBI reporting. I'm trying to divide a sales measure by the 'units per case' field in related dimension table. The formula below works BUT when a item doesnt have a value or contains a zero for the unit per case amount the record returns with 'Infinity' and 'NaN'. 

Estimated Cases = SUMX('ActualSales', 'ActualSales'[SalesNetQty] / RELATED('ProductDetail'[UnitsPerCase]))

Any help would be appreciated.. thanks

[HotChilli · Accepted solution]

Use the DIVIDE function https://dax.guide/divide/