Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |