Problem with BLANK value

[Sleathbcn]

Hello,

I would like to know if someone can help me. In this DAX formula I would like that in case any of variables returns a BLANK value, instead of BLANK it is "Zero". Thks a lot!!

Deuda a LP =

VAR Deudalp =

CALCULATE(

[BS],

dBalance[CUENTA] = "170"

)

VAR Deudalpvinculadas =

CALCULATE(

[BS],

dBalance[CUENTA] = "160"

)

VAR Result =

Deudalp + Deudalpvinculadas

RETURN

Result

[tackytechtom · Accepted solution]

Hi @Sleathbcn ,

How about 

IF ( result = BLANK(), 0, result )

Does this help? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Sleathbcn]

Yes!! Thks Tom.

Rgds