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))).

powerbiadmin123's avatar
powerbiadmin123
Frequent Visitor
4 years ago

HI!

Thank you for your reply! However, I am still having the same issue when calculating my average, this is my measure; 

 

AVG Fill Rate =
VAR __Table =
ADDCOLUMNS(
'REC_HDR_Append',
"__Fill Rate",[Fill Rate 2 ]
)
RETURN
AVERAGEX(__Table,[Fill Rate 2])

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi powerbiadmin123 ,

    Could you please provide more sample data with Text format and the formula of SumF64 and SumOrderQty in order to make troubleshooting? I just tried to reproce your problem,but it failed.... I can get the correct average value, please check the below screenshot and the attachment for more details.

    Best Regards