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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
cosmasadesegha
Frequent Visitor

Subtotal rounding issue

I am wondering why my subtotal is not rounding as expected. I expect to see $26,680.37 but was getting $26,680.35 as shown below. Kindly help

 

cosmasadesegha_0-1616687511157.png

 

4 REPLIES 4
AlexisOlson
Super User
Super User

In most cases, the subtotal will show the sum of the actual underlying numbers, rounded to a certain number of decimal places, rather than the sum of the displayed numbers, which may be rounded.

 

If you expect your rounded subtotals to always be the sum of the rounded components then you are not going to have a good time in general since the requirement leads to showing inaccurate totals or inaccurate components.

amitchandak
Super User
Super User

@cosmasadesegha, Are you trying to add two decimal places, that is not correct. Please increase decimal place(Say 5) and check the total again

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Angith_Nair
Continued Contributor
Continued Contributor

Hi @cosmasadesegha ,

Please change the decimal places for Burdened Amount to 0. This will also round up the measure values and at last, subtotal will also give round-off value.

Thanks for your prompt response. If I change the decimal places to 0, I will get a whole number value and that is not what I want to get. I want it in two decimal places but having the subtotal rouding up and not down.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors