Forum Discussion

Rdarshana's avatar
Rdarshana
Helper II
2 years ago
Solved

How to display Inverse Percentage for a Field?

Hi, I have a field that displays the value as 0.73, 0.82, 0.91, etc,. The need is to display these values as Percentage.  But, this needs to be inverse percentage - that is: 1-0.73 = 0.27 ~ 27%....
Need Help
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Rdarshana 

    you can try to create a new column

    Column = 1-'Table'[Column1]
    and set the data type to percentage
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    pls try this

    measure = 1- max(Original Col)

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

Rdarshana 

you can try to create a new column

Column = 1-'Table'[Column1]
and set the data type to percentage
  • Rdarshana's avatar
    Rdarshana
    Helper II
    2 years ago

    Hi,
    Thanks for showing the calc. I see that it works when I add a new column in the same table. 
    However, when I create the calculated column under Measures folder, it just displays 1.00 in the report.
    Just curious, as to why would PBI calc behave like this.
    Calc is simple = 1-Orginal col.

     

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      2 years ago

      pls try this

      measure = 1- max(Original Col)

      • Rdarshana's avatar
        Rdarshana
        Helper II
        2 years ago

        So, I tried this - 

        New Measure = 1-MAX(table name [ columne name]), and it still displays 1.00.

        Thus, for now, I shall retain this as a new column in the current table, since that is working.