Average Fill Rate Calculation Help

[Anonymous]

Hello,

I am trying to calculate the average fill rate (Qty Received divided by Qty Ordered) by vendor for PO (purchase order) Numbers where the PO's status (Status column) is C (closed). Qty Received is housed in the PO Receipt table and Qty Ordered is housed in the PO Detail table. The Status column exists in the PO Master table and PO Receipt table but not the PO Detail table. I am not sure how to build a fill rate key measure that only accounts for received and ordered quantities on PO's that have a Status of C. Pbix file location attached.

https://1drv.ms/u/s!AiFttrDOn_FqgQ_5ArArPmJ4oVcn

Any assistance is appreciated.

[jericacoleman · Accepted solution]

I would add a quick measure that defines the fill rate calculation.

Calculation = Division

Numerator = Qty Received from the PO Receipt table

Denominator = Qty Ordered from the PO Detail table

The quick measure will pop up in in whatever table you have highlighted and you will want to change it to a percentage through the Modeling tab and rename it as the default will be the expression.

Then you can create a table with the Vendor Name and Fill Rate (or whatever your rename the quick measure). 

Looking at your data it appears you have a page level filter that is choosing only PO's with a status of C that do no equal PO number 00003765, so that should filter appropriately for you.