Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Convert 43.39999999999999 to 44.4

I have a column in a table that looks up a related value. The related value is 44.4

 

Unfortunately, one of the values that returns is 43.399999999999999. It does not mean much in a world view, but apparently it does when I do the visualizations and zoom in using slicers, as per the image below.

 

Picture1.png

 

I tried to fix using round,

 

Score = round(RELATED(table[column]),1)

 

,and when I view in the table setting, it shows 44.4, but when I go to visualize, I have the same issue

 

Any suggestions how to overcome this.

 

Kind regards

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Sorted by rounding to zero digits

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Sorted by rounding to zero digits

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.