Forum Discussion

nleuck_101's avatar
nleuck_101
Continued Contributor
4 years ago
Solved

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.1...
Need Help
  • rsbin's avatar
    rsbin
    4 years ago

    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's avatar
nleuck_101
Continued Contributor
4 years ago

rsbin,

 

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

rsbin's avatar
rsbin
Community Champion
4 years ago

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's avatar
    nleuck_101
    Continued Contributor
    4 years ago

    rsbin 

     

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