- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you can try to create a new column
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you can try to create a new column
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Subject | Author | Posted | |
---|---|---|---|
07-24-2024 07:41 PM | |||
01-20-2025 05:08 PM | |||
12-16-2024 04:42 AM | |||
10-18-2024 12:38 PM | |||
06-13-2024 05:11 AM |
User | Count |
---|---|
141 | |
110 | |
81 | |
61 | |
46 |