Problems with value 0.00

[AndradeRobson]

Goodnight!

I need help with the value 0.00 in the DAX measure, as it is leaving the graph value with an error of 2.05E11 instead of 0.00.

How could I solve it?

Below is the function used.

CALCULATE([Movement by Filter CNPJ Menu x CNPJ PL Contas],FILTER(ALL(dCalendario),dCalendario[Data]<=MAX(dCalendario[Data])))

Att.

[Ritaf1983 · Accepted solution]

Hi @AndradeRobson 
Try to use a dynamic string format, it should help.

All guides show currencies, but it works perfectly on numbers too.

https://www.youtube.com/watch?v=s4jeX9EKON4

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Ritaf1983 · Accepted solution]

Hi @AndradeRobson 
Try to use a dynamic string format, it should help.

All guides show currencies, but it works perfectly on numbers too.

https://www.youtube.com/watch?v=s4jeX9EKON4

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[AndradeRobson]

Thanks for the tip.

But the table number 0.00 still appears in this strange format on the graph.
Has anyone had this problem?

Att.

Robson

[Ritaf1983]

@AndradeRobson  please share dummy pbix and i will check it.

[AndradeRobson · Accepted solution]

Rita, good morning!

Thank you very much for the tips.
I believe that POwer Bi had a bug, because in the view, I deleted the DAX function, updated all the tables and then added the function again and it worked.

Att.

Robson