cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

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....
Capture.JPG
Thanks in advance forall your help
Best regards

Pedro

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Wrong formated measure?

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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: Wrong formated measure?

@pedromooji , this is strange. Change your data type decimal or whole number once and check.

 

Data Format New Rib.png



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper V
Helper V

Re: Wrong formated measure?

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.

General & 0.JPGWhole number & 0.JPG
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?

Highlighted
Super User IV
Super User IV

Re: Wrong formated measure?

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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Helper V
Helper V

Re: Wrong formated measure?

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

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors