Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Rdarshana
Helper I
Helper I

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%. 

Is there a DAX formula that can help with this? 

2 ACCEPTED SOLUTIONS
ryan_mayu
Super User
Super User

@Rdarshana 

you can try to create a new column

Column = 1-'Table'[Column1]
and set the data type to percentage
11.PNG




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

pls try this

measure = 1- max(Original Col)





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
ryan_mayu
Super User
Super User

@Rdarshana 

you can try to create a new column

Column = 1-'Table'[Column1]
and set the data type to percentage
11.PNG




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.

Rdarshana_0-1721952414133.png

 

pls try this

measure = 1- max(Original Col)





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.