Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Division: No numerator

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's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    You can try

    Measure1 =
SUMX ( 'Table', COALESCE ( DIVIDE ( 'Table'[Column1], 'Table'[Column2] ), 0 ) )
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Anonymous 
You can try

Measure1 =
SUMX ( 'Table', COALESCE ( DIVIDE ( 'Table'[Column1], 'Table'[Column2] ), 0 ) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you, tamerj1 !  It works well.