Measure not calculating correctly

[nleuck_101]

Hello All,

I could use some help with my percent measure not calculating correctly. My measure is the 3rd column divided by 4th column. Both columns are measures. If you divide 1 / 6 you get 16.17% but I get 18.18%. Also, the total should be 1 / 31 and 3.23% but I get 3.28%. I've had trouble with understanding why Power BI works like this but any help would be greatly appreciated.

Thanks!

[rsbin]

@nleuck_101,

Are you sure the values in your 3rd and 4th columns are exact and are not rounded up?

1/5.5 = 18.18% or 1.0908 / 6 = 18.18% ?

[nleuck_101]

@rsbin,

I changed the format from General to Whole Number for the 3rd and 4th column.

[rsbin · Accepted solution]

@nleuck_101,

Even though you changed the format, the value of your Measures are still decimal numbers.

You can change the value by using a DAX ROUND (or Roundup, Rounddown ) function to generate whole numbers if that is what you truly want your Measures to reflect

[nleuck_101]

@rsbin 

Thank you! I used the ROUNDUP function and that worked perfectly.