Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Numerical formats

Hello All,

I am using dax measure to calculate the result for division of two counts for two columns, the issue that I always got an integer approximated result ( for example when the actual division result is 0.68 I got 1)!!

how can we change the result numeric format to show the exact value without approximation to nearest integer? Thank you

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Select your measure and go to the ribbon above . Click on the dropdown and select Decimal Number

     

     

     

    Regards,
    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      This is not working!! The result is still Integer!! 
      I can change the format to each one of this but it is only applied to the integer value for example 1, 1,00, 100%, 100.00% ... etc. The problem is in the Dax code that did the approximation!! 
      I have these values for the different counts of two columns: 1024 & 860. 
      so 860/1024=0.839

      I got 1 & not 0.839. I hope it is now clear. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

         

        Not sure why are you getting 1.  This is what I get.

         

         

         

         

        Regards,
        Harsh Nathani

        Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)