how do I return zero instead of empty?

[aignn]

Hi all!

I need help 😃

I have measure:

Measure = var test = "2020-01-18T00:00:00"
return 
CALCULATE(MAX('query1'[Complete]));'query1'[Date] = test)

The result is an empty value. It is right. Because there is no data for this date yet. But is it possible to output zero instead of empty?

[az38 · Accepted solution]

Hi @aignn 

try

Measure = var test = "2020-01-18T00:00:00"
var _Result = CALCULATE(MAX('query1'[Complete]));'query1'[Date] = test)
return 
if(isblank(_Result);0;_Result)

[aignn]

@az38 Super! Thanks!