modify measure to get default value 0

[reynold522]

count of deepdischarge = SUMX ( VALUES ( 'Table'[IoT device ID] ), IF ( [Deep Discharge hour]> 1, 1 ) )

this code will have value blank. 

how Can I get value 0 as default if none of IoT device has deep discharge

Thanks in advance

Best regards

[tamerj1]

Hi @reynold522 

you can use

count of deepdischarge = SUMX ( VALUES ( 'Table'[IoT device ID] ), IF ( [Deep Discharge hour]> 1, 1, 0 ) )

[FreemanZ · Accepted solution]

try like

count of deepdischarge =

VAR _value= SUMX ( VALUES ( 'Table'[IoT device ID] ), IF ( [Deep Discharge hour]> 1, 1 ) )

RETURN 

IF( _value=BLANK(), 0, _value )