Forum Discussion

powerbiadmin123's avatar
powerbiadmin123
Frequent Visitor
4 years ago

Total Average with 0% values

Hello Everyone,    I'm trying to find the total average of my fill rate percentages. This is the measure used for my fill rate;  Fill Rate = (IF(DIVIDE([SumF64],[SumOrderQty])>1,1,DIVIDE([SumF64]...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

powerbiadmin123 , Try like

 

Fill Rate = (IF(DIVIDE([SumF64],[SumOrderQty],0)>1,1,DIVIDE([SumF64],[SumOrderQty],0))).