Forum Discussion

nleuck_101's avatar
nleuck_101
Icon for Continued Contributor rankContinued 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

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
4 years ago

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

    rsbin,

     

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

    • rsbin's avatar
      rsbin
      Icon for Community Champion rankCommunity 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
        Icon for Continued Contributor rankContinued Contributor
        4 years ago

        rsbin 

         

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