How to return 0 instead of (Blank) for this Dax Command?

[Omarion84]

How to return 0 instead of (Blank) for this Dax Command when we do not have any disconnects?

No Of Disconnects = CALCULATE([No of Orders], FILTER(ORDERS, ORDERS[ORDER_STATUS] = "Accepted" ),

 FILTER(ORDERS, ORDERS[ORDER_TYPE] = "Disconnect" ))

[AnthonyGenovese · Accepted solution]

I would try something like this.
No Of Disconnects = 
var preResult =CALCULATE([No of Orders], FILTER(ORDERS, ORDERS[ORDER_STATUS] = "Accepted" ),

 FILTER(ORDERS, ORDERS[ORDER_TYPE] = "Disconnect" ))
var result = if(isblank(preResult),0,preResult)
return result

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!