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
First, create a new measure that sums IndicatorValue[Value]:
Indicator Values = calculate(sum(IndicatorValue[Value]))
Next, create a new measure that counts Equipment[Description] regardless of context (that is, filters on other fields):
Machine Count = calculate( DISTINCTCOUNT( Equipment[Description]), All( Equipment ) )
If you have fields for which you want to maintain the context (that is, if you have a slicer for Factory and you want the denominator of your productivity quotient to include only machines in that factory, you can use AllExcept, e.g.:
Machine Count = calculate( DISTINCTCOUNT(Equipment[Description]), AllExcept(Equipment,Equipment[Factory]))
Finally, a new measure that calculates the quotient:
Productivity = [Indicator Values]/[Machine Count]
Use the modeling tab to set the format of Productivity to a percentage.
I made the suggested change prem the value that is reported when converted to percent% is 885205,021% ie the format is still incorrect, it should display 88.52%