Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
you can try to create a new column
Proud to be a Super User!
pls try this
measure = 1- max(Original Col)
Proud to be a Super User!
you can try to create a new column
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.
pls try this
measure = 1- max(Original Col)
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.
User | Count |
---|---|
123 | |
76 | |
63 | |
50 | |
50 |
User | Count |
---|---|
175 | |
125 | |
60 | |
60 | |
58 |