Forum Discussion
Convert the value to%
Hi Anonymous,
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
Anonymous
when you divide a total into a count that is usually to get an average number. ie the average value, What is the measure called and what is its purpose?
so when you say value/ count what do those number refer to and what are you trying to do, hope that makes sense
The purpose is to know the efficiency% of production of a machine, the sum (esá adding the produced items) and count (counting the quantity of machines in production)