Forum Discussion
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%.
Is there a DAX formula that can help with this?
pls try this
measure = 1- max(Original Col)
4 Replies
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.pls try this
measure = 1- max(Original Col)
