topic Re: Division: No numerator in DAX Commands and Tips

Division: No numerator

Anonymous — Tue, 14 Feb 2023 09:47:34 GMT

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.

Re: Division: No numerator

tamerj1 — Tue, 14 Feb 2023 12:04:36 GMT

Hi Anonymous
You can try

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

Re: Division: No numerator

Anonymous — Thu, 16 Feb 2023 08:38:46 GMT

Thank you, tamerj1 ! It works well.