Forum Discussion
Measure not calculating correctly
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!
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
4 Replies
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% ?
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
