Calculate

[jhodasoft]

Good afternoon! The idea is to put zero and not blank spaces. Can someone help me?

I did the following (see image) but the filter does not recognize me and sets the entire context to zero. Thanks for the support provided.

[tamerj1 · Accepted solution]

@jhodasoft 

Please try

=
IF (
NOT ISEMPTY ( fact_saidi_saifi ),
COALESCE (
CALCULATE (
DIVIDE ( [Total_afec], [min_cliente] ),
fact_saidi_saifi[gendist] = "T"
),
0
)
)

[jhodasoft]

@tamerj1 It worked!, Thank you very much for the support. Greetings from Iquitos, Loreto, Perú.

[tamerj1]

@jhodasoft 

Pretty sure it's a beautiful place 

[FreemanZ]

hi @jhodasoft 

in the code of your first screenshot, try to add "+0" in the end. 

like:

CALCULATE(...)+0

[jhodasoft]

@FreemanZ  Thanks for answering, I did it and it keeps putting zero to everything, the filter doesn't recognize me

[FreemanZ]

hi @jhodasoft 

consider providing sample dataset with expected result.