Forum Discussion

mfminor's avatar
mfminor
Helper I
9 years ago

Percentage not properly sorting

I have a table that is sorting the percentages I have calculated as text instead of a number. However, I am not sure how to fix this.

 

Ratio Returned to Produced = FORMAT(DIVIDE(counta(RootCause_Query[Unit Model]),MAX(RootCause_Query[Total Produced]), "no result"), "percent")

This is the measure I created. If I am understanding correctly, since I am using the format function my percentages should already be "numbers" and sort as such. Instead when I sort I am seeing 7.7 6.6 5.5 4.2 3.5 2.1 15.8 17.2 1.3 etc. Any suggestions? I am sure this is a simple fix I will kick myself over later. 

Need Help

3 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    mfminor

     

    The format transform your number to Text.

     

    If you want to change your Measure to Percent do this:

     

    -Delete the Format Function in your measure

    -Select your measure 

    -Go to Modeling

    -Format -- Percentage

    • mfminor's avatar
      mfminor
      Helper I
      9 years ago

      "-Delete the Format Function in your measure"

       

      When I perform this step it breaks my table visual and when I click on my measure and go to the modeling tab the only format I can choose is text.