topic Round function not rounding in DAX Commands and Tips

Round function not rounding

Anonymous — Fri, 03 Jan 2020 19:21:26 GMT

I have used the round function to round to 2 decimal places, but when I export my reports, the numbers are coming out almost rounded, but not quite (for example, 27,343.0900000001). Any idea why this is happening?

Re: Round function not rounding

Greg_Deckler — Fri, 03 Jan 2020 19:38:07 GMT

What are you doing to export the reports? You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Re: Round function not rounding

Anonymous — Mon, 06 Jan 2020 18:58:51 GMT

Thanks, I will post there.

I do have another question, perhaps I am doing something wrong. I have a table with a field that is rounded using the round function, and then another table that is just 1/2 of the sum of that field. If I leave the second table unrounded, it = half of the sum of the first table. If I put the round function on the second table, the amount is off by a few dollars. Any ideas?

Re: Round function not rounding

JarroVGIT — Mon, 06 Jan 2020 20:35:50 GMT

Are you using SUM (ROUND ([column]) )? Because that would first ROUND it and then sum the Rounded numbers. The other way arround will sum the colum and then round the result. So if I have two value, 4.02, 5.49 and go with the SUM(ROUND()), it would be 4 + 5 = 9. If I go with ROUND(SUM()) it would be ROUND(4.02+5.49) = ROUND(9.51) = 10.

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

Re: Round function not rounding

Anonymous — Mon, 06 Jan 2020 21:12:54 GMT

That is helpful and makes sense, but I don't think quite fixes the issue. I wasn't very specific in my initial question, so let me try to do a better job of describing what's going on. I'm actually not using a sum function, I just do not have the other fields that break the data into multiple lines like in the first table so it is presented in a summarized way. So for example:

Table 1
Account Number	Amount
acct 123	128,544.44
acct 345	200,000.00
acct 789	20,048.44

Table 2- not rounded
Acount Number	Half Amount
act 000	=0.5*Amount

Table 2- rounded
Account Number	Half Amount
act 000	=round(0.5*Amount,2)

The first one that is not rounded gives me the correct number, 174,296.44. The one that is rounded gives me a different number: 174,299.84

It might also be worth mentioning that Amount in the first table has the rounding formula in it as well.

Re: Round function not rounding

JarroVGIT — Mon, 06 Jan 2020 21:30:16 GMT

I can't seem to reproduce the problem with hard values:

I get the same results?

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

Re: Round function not rounding

Anonymous — Tue, 07 Jan 2020 14:38:00 GMT

Thanks for taking a look, that makes me feel better-- I would expect to get the same results as well so I wonder if it's a bug related to the rounding issue in my original question.

Re: Round function not rounding

Anonymous — Thu, 23 Jul 2020 14:03:46 GMT

I am having the same problem. Regardless of how I implement the round function (I have tried every iteration), it seems to have issues. Some of my numbers round while others do not. I believe this is a Power BI bug.

Re: Round function not rounding

Echi — Sun, 29 Sep 2024 02:29:32 GMT

I discovered that the Table View> format> rounding needed to be swiched from "auto" to the desired 2 digits.

this seems to hard lock to two digits in the viewed tables, and my csv's now export correctly.

(whereas rounding to 2 digits in Dax or Query kept generating the rounding artifacts.)