Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Wrong formated measure?

Hi guys I believe this is not only a format problem, but i don't have enough knowledge to understand it. Did this happened to any of you guys? As you may see, this total should be 0.... Thank...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    I faced this E-8 In PostgreSQL DB but their database was treating it as null, so get rid by using coalesce. Power BI supported this recently. Try to use coalesce on top of you formula

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello amitchandak 
THank you for the answer.
So, i've tried (i think i've already did it) to change all the ways and it never works.


I thought it was a data problem and i've check in excel. It's all good BUT i get the same error.
Let me tell you that these values are "sales" and "credit notes".  This 1E-11 shows that this "account" is balanced, is = 0. 
It never happen to us until you do, right?
Do you have some ideas?

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

I faced this E-8 In PostgreSQL DB but their database was treating it as null, so get rid by using coalesce. Power BI supported this recently. Try to use coalesce on top of you formula

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi again amitchandak 
    Again, nothing worked. But the Coalesce function helped to find the "error". I don't know about this but now this measure is formated as whole number, fixed and zero decimals. In the vizualizations, Data label tab, you have to put Auto as display units. Otherwise it won't work. I really don't know why or what this means, but it's working now,
    Again, thank you so much for your help
    Best regards

    Pedro