how to handle zero or null values in measure

[Snagalapur]

Hi All,

Please suggest how to handle zero or null values in below measure

Thank you.

[johnt75]

Use the DIVIDE function rather than the / operator.

[Jai-Rathinavel · Accepted solution]

@Snagalapur  you can set the zero values as blank like below expression

Sales =

var num = SUM(Table[Sales])

var den = SUM(Table[Gross])

var a = DIVIDE(num,den,0)

return

IF(a == 0, BLANK(), a)

Thanks,

Jai

[Snagalapur]

Thank you for help.