Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a measure in which I must bring the value of it inwardly and also in percentage:
Productivity = (sum (IndicatorValue [Value]) / COUNT (Equipment [Description]))
When I bring the information in integer, the information comes in correctly, but when I bring it in the percentage format it does not treat the information, applying only the% to the end of the value, thus leaving the incorrect value.
In this case the value to be presented in% would be 85.68%.
What should I do to get the correct value in% displayed as I expect?
Solved! Go to Solution.
Hi @vitexo87,
Agree with @vanessafvg.
Your issue is caused by that the Productivity measure returns a value which is greater than 1, when you convert it to percentage in Power BI, the Productivity value will be multiplied by 100 and be displayed with % added. Only when the Productivity measure returns a value which is less than 1, you will get a percentage value within 100%.
If you want to make the current measure return 0.8568, you would need to write the measure using : ((sum (IndicatorValue [Value]) / COUNT (Equipment [Description])))*0.0000001. This way, when you convert it to %, you will get 85.68%. However, I don’t think the above formula makes any sense, as you manually multiply the measure by 0.0000001.
Regards,
Lydia Zhang
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |