Forum Discussion

Tejasvi_munge's avatar
Tejasvi_munge
Frequent Visitor
6 years ago
Solved

keep zero after decimal

Hi All,   I have a column containing values like 2.3456, 2.304 etc And I want to limit values upto two decimal points. Also, I cannot use option which modelling ribbon provides beause I am connect...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    You can change measure's format:

    Or use VALUE function:

    measure 2 = VALUE([measure])

    Or if you just want to sort, please try to create a rank measure:

    rank = RANKX(ALLSELECTED('Table_1'),VALUE([Measure]),,DESC,Dense)

    And then sort number by this rank.

     

    Best Regards,

    Giotto Zhi

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try to use FIXED function to create a measure to show the data format you want, like this:

Measure = FIXED(SELECTEDVALUE(Table_1[Data]),2)

You can specific any number of decimal you want by this function, and it shows:

Hope this helps.

 

Best Regards,

Giotto Zhi

  • Tejasvi_munge's avatar
    Tejasvi_munge
    Frequent Visitor
    6 years ago

    Hi,

     

    Thank you for suggestion! 

    But Fixed changes the data type into text and will not give correct output while sorting 

    For ex- consider values like 9.8, 9.1,10.3

    Sorting(desc order) after using Fixed will give output like-9.8, 9.1, 10.3 and not 10.3, 9.8, 9.1   

    • v-gizhi-msft's avatar
      v-gizhi-msft
      Community Support
      6 years ago

      Hi,

       

      You can change measure's format:

      Or use VALUE function:

      measure 2 = VALUE([measure])

      Or if you just want to sort, please try to create a rank measure:

      rank = RANKX(ALLSELECTED('Table_1'),VALUE([Measure]),,DESC,Dense)

      And then sort number by this rank.

       

      Best Regards,

      Giotto Zhi