Forum Discussion

AndradeRobson's avatar
AndradeRobson
Helper II
2 years ago
Solved

Problems with value 0.00

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. CALCULA...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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's avatar
    AndradeRobson
    2 years ago

    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

AndradeRobson's avatar
AndradeRobson
Helper II
2 years ago

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's avatar
Ritaf1983
Super User
2 years ago

AndradeRobson  please share dummy pbix and i will check it.

  • AndradeRobson's avatar
    AndradeRobson
    Helper II
    2 years ago

    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