Forum Discussion
Solved
Calculate
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. Tha...
Please try
=
IF (
NOT ISEMPTY ( fact_saidi_saifi ),
COALESCE (
CALCULATE (
DIVIDE ( [Total_afec], [min_cliente] ),
fact_saidi_saifi[gendist] = "T"
),
0
)
)
