topic Re: Calculate in DAX Commands and Tips

Calculate

jhodasoft — Fri, 17 Feb 2023 21:38:27 GMT

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.

FreemanZ — Fri, 17 Feb 2023 23:15:53 GMT

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

like:

CALCULATE(...)+0

jhodasoft — Fri, 17 Feb 2023 23:44:42 GMT

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

FreemanZ — Sat, 18 Feb 2023 06:11:24 GMT

consider providing sample dataset with expected result.

tamerj1 — Sat, 18 Feb 2023 13:19:25 GMT

Please try

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

jhodasoft — Sat, 18 Feb 2023 14:29:19 GMT

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

tamerj1 — Sat, 18 Feb 2023 14:45:25 GMT

Pretty sure it's a beautiful place