Forum Discussion
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....
Thanks in advance forall your help
Best regards
Pedro
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
4 Replies
- amitchandak
Super User
Anonymous , this is strange. Change your data type decimal or whole number once and check.
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
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