cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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
Super User

you can try to create a new column

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

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

Proud to be a Super User!

Super User

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!

4 REPLIES 4
Super User

you can try to create a new column

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

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

Proud to be a Super User!

Frequent Visitor

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.

Super User

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!

Frequent Visitor

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.