cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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],[SumOrderQty]))).

My problem is that when creating an average measure it works fine until 0% are included, I understand this happens since the zero values are not included when using the if function in the fill rate measure. How could I create an average function that includes all my values even when being zero?

3 REPLIES 3
Super User

@powerbiadmin123 , Try like

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

Frequent Visitor

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 =
'REC_HDR_Append',
"__Fill Rate",[Fill Rate 2 ]
)
RETURN
AVERAGEX(__Table,[Fill Rate 2])

Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors