Division: No numerator

[Anonymous]

Hello,

I would like to write a measure, which would divide Column1 by Column2, and provide 0 when there is no numerator, i.e. value in Column1. Whereas, currently I get a blank.

[tamerj1 · Accepted solution]

Hi @Anonymous 
You can try

Measure1 =
SUMX ( 'Table', COALESCE ( DIVIDE ( 'Table'[Column1], 'Table'[Column2] ), 0 ) )

[Anonymous]

Thank you, @tamerj1 !  It works well.