# Power BI Inventory app KPIs and measures
> APPLIES TO: Generally available in Business Central 2024 release wave 2.
This page provides a list of all Key Performance Indicators (KPIs) included in the semantic model for the Power BI Inventory app. Explore the list of KPIs to learn more about how they can help you achieve your business goals. Each KPI is described, including how it's calculated and the data is uses in calculations.
> TIP
> You can easily track the KPIs that the Power BI reports display against your business objectives. See Track your business KPIs with Power BI metrics<track-kpis-with-power-bi-metrics>.
## Assembly header measures
 #qty-on-assembly-order
### Qty. on Assembly Order
Formula
 This measure shows how many items are yet to be assembled for assembly orders by summing up the remaining quantity of items on all assembly headers.
Data Sources
 Assembly Header
## Assembly Line Measures
 #qty-on-asm-component
### Qty. on Asm. Component
Formula
 This measure shows how many items are yet to be assembled for a finished product by summing up the remaining quantity of items on all assembly lines.
Data Sources
 Assembly Line
## Bins Measures
 #ato-components-pick-qty
 #available-qty-to-take
 #negative-adjmt-qty-base
 #pick-quantity-base
 #positive-adjmt-qty-base
 #put-away-quantity-base
 #quantity-in-adjustment-bin
 #warehouse-quantity
### ATO Components Pick Qty.
Formula
 This measure calculates the total quantity taken from the warehouse for "Assemble to Order" components by summing the qtyBase from Warehouse Activity Lines where actionType is Take, assembleToOrder is TRUE, and atoComponent is TRUE. This measure captures only the quantities picked specifically for assembling made-to-order products.
Data Sources
 Warehouse Activity Line
### Available Qty. to Take
Formula
 This measure calculates the quantity of an item that is available to be picked. It subtracts the #pick-quantity-base, #ato-components-pick-qty, and #negative-adjmt-qty-base measures from #warehouse-quantity, but only for the bins that are not marked as adjustment bins.
Data Sources
 Warehouse Entry
 Bin
### Negative Adjmt. Qty. (Base)
Formula
 This measure calculates the total quantity of an item that has been removed from the warehouse due to adjustments. This includes any adjustments that result in inventory decreases in the Warehouse Journal Line table.
Data Sources
 Warehouse Journal Line
### Pick Quantity (Base)
Formula
 This measure calculates the total quantity of an item that has been picked from the warehouse for sales or transfer orders. It only includes the quantity that was picked, not received or moved within the warehouse.
Data Sources
 Warehouse Activity Line
### Positive Adjmt. Qty. (Base)
Formula
 This measure calculates the total quantity of an item that was added to the warehouse due to adjustments. This includes any adjustments that result in inventory increases in the Warehouse Journal Line table.
Data Sources
 Warehouse Journal Line
### Put-away Quantity (Base)
Formula
 This measure calculates the total quantity of an item that was placed in the warehouse for storage. It only includes the quantity that has been put away, not picked or moved within the warehouse.
Data Sources
 Warehouse Activity Line
### Quantity in Adjustment Bin
Formula
 This measure calculates the total quantity located in bins that are marked as adjustment bins. It first identifies the bins flagged as adjustment bins by creating a filtered table (AdjustmentBins). Then, it sums the Qty. (Base) values from the Warehouse Entries table, applying this filter to include only adjustment bins. The measure ensures the quantity reflects only the specified adjustment bins by removing other bin filters.
Data Sources
 Warehouse Entry
 Location
### Warehouse Quantity
Formula
 This measure calculates the total quantity of an item that is currently in the warehouse by summing the base quantity from the Warehouse Entry table.
Data Sources
 Warehouse Entry
## Item Availability Measures
 #gross-requirement
 #planned-order-receipt
 #planned-order-releases
 #projected-available-balance
 #scheduled-receipt
### Gross Requirement
Formula
 This measure calculates the total quantity of an item that's needed to fulfill various orders and projects. It includes the quantity on sales orders, service orders, projects, production order component lines, transaction order shipments, planning issues, assembly components, and purchased returns.
  Gross Requirement = #qty-on-sales-order + #qty-on-service-order + #qty-on-projects + #qty-on-prod-order-comp-lines + - #trans-order-shipment-qty + #planning-issues-qty + #qty-on-asm-component + #qty-on-purch-return
Data Sources
 Sales Line
 Purchase Line
 Transfer Line
 Service Line
 Job Planning Line
 Prod. Order Component
 Planning Component
 Assembly Line
### Planned Order Receipt
Formula
 This measure shows the total quantity of items that you plan to receive through planned orders and purchase requisitions.
  Planned Order Receipt = Planned Order Receipt (Qty.) + Purch. Req. Receipt (Qty.)
Data Sources
 Production Order Line
 Requisition Line
### Planned Order Releases
Formula
 This measure shows the total quantity of items that you plan to release through planned orders and purchase requisitions.
  Planned Order Releases = Planned Order Release (Qty.) + Purch. Req. Release (Qty.)
Data Sources
 Production Order Line
 Requisition Line
### Projected Available Balance
Formula
 This measure calculates the current inventory quantity, planned order receipts, scheduled receipts, and gross requirements based on the data up to the most recent date available.
  Projected Available Balance = #inventory-quantity + #planned-order-receipt + #scheduled-receipt - #gross-requirement
Data Sources
 Sales Line
 Purchase Line
 Transfer Line
 Service Line
 Job Planning Line
 Prod. Order Component
 Planning Component
 Assembly Line
 Item Ledger Entry
 Requisition Line
 Production Order Line
### Scheduled Receipt
Formula
 This measure shows the total quantity of items that are scheduled for receipt.
  Scheduled Receipt = #fp-order-receipt-qty + #rel-order-receipt-qty + #qty-on-purch-order + #qty-in-transit + #trans-order-receipt-qty + #qty-on-assembly-order + #qty-on-sales-return-order
Data Sources
 Sales Line
 Purchase Line
 Transfer Line
 Assembly Header
 Production Order Line
## Item Ledger Entry Measures
 #expired-inventory
 #inventory-quantity
 #invoiced-quantity
 #net-qty-purchased
 #net-qty-sold
 #quantity
 #quantity-forecasting
 #remaining-quantity
### Expired Inventory
Formula
 This measure shows how much inventory is expired and no longer available for sale or use. It calculates the remaining quantity of items on all item ledger entries.
Data Sources
 Item Ledger Entry
### Inventory (Quantity)
Formula
 This measure shows the total quantity of inventory on hand for all items. It sums up the quantity of items on all item ledger entries.
Data Sources
 Item Ledger Entry
### Invoiced Quantity
Formula
 This measure calculates the total quantity that was invoiced. It sums all values in the [invoicedQuantity] column from the Item Ledger Entries table.
Data Sources
 Item Ledger Entry
###  Net Qty. Purchased
Formula
 This measure shows the total quantity of items that you purchased and received calculating the quantity, filtered to only include item ledger entries that have an entry type of "Purchase".
Data Sources
 Item Ledger Entry
###  Net Qty. Sold
Formula
 This measure shows the total quantity of items that you sold by calculating the quantity, filtered to only include item ledger entries that have an entry type of "Sale".
Data Sources
 Item Ledger Entry
> TIP
> You can easily track the KPIs that the Power BI reports display against your business objectives. See Track your business KPIs with Power BI metrics<track-kpis-with-power-bi-metrics>.
### Quantity
Formula
 This measure shows the total quantity of items that you processed through the item ledger by summing up the quantity of items on all item ledger entries including sales, purchases, adjustments, and other types of transactions.
Data Sources
 Item Ledger Entry
### Quantity (Forecasting)
Formula
 This measure calculates the Quantity within the period of dates with item transactions and inserts zero values for dates without item ledger entries, for compatibility with forecasting.
Data Sources
 Item Ledger Entry
### Remaining Quantity
Formula
 This measure calculates the total remaining quantity of items by summing all values in the [Remaining Qty.] column from the Item Ledger Entries table.
Data Sources
 Item Ledger Entry
## Planning Component Line Measures
 #planning-issues-qty
### Planning Issues (Qty.)
Formula
 This measure shows how many items you expect to consume for planned production orders by summing up the expected quantity of items that are required for production.
Data Sources
 Planning Component
## Prod. Order Component Line Measures
 #qty-on-prod-order-comp-lines
### Qty. on Prod. Order Comp. Lines
Formula
 This measure shows how many items are yet to be completed on a production order by summing up the total remaining quantity of items on all production order component lines.
Data Sources
 Prod. Order Component
## Production Order Line Measures
 #fp-order-receipt-qty
 #qty-on-prod-order
 #rel-order-receipt-qty
 #scheduled-receipt-qty
### FP Order Receipt (Qty.)
Formula
 This measure is abbreviated for Firmed Planned Order Receipt (Qty.) and shows how many items you expect to receive for firm planned production orders by summing up the remaining quantity of items on all firm planned production order lines.
Data Sources
 Production Order Line
### Qty. on Prod. Order
Formula
 This measure shows how many items are yet to be produced for production orders by summing up the remaining quantity of items on all planned, firm planned, and released production order lines.
Data Sources
 Production Order Line
### Rel. Order Receipt (Qty.)
Formula
 This measure is abbreviated for Released Production Order Receipt (Qty.) and shows how many items are expected to be received for released production orders by summing up the remaining quantity of items on all released production order lines.
Data Sources
 Production Order Line
### Scheduled Receipt (Qty.)
Formula
 This measure calculates the total scheduled receipt quantity from production orders by summing the [remainingQtyBase] column in the Production Order Lines table. It includes only those orders where the status is either Firm Planned or Released, which represents production orders expected to be completed. This measure gives an overview of pending quantities that are scheduled for receipt in the near future.
Data Source
 Production Order Line
## Project Planning Line Measures
 #qty-on-projects
### Qty. on Projects
Formula
 This measure shows how many items or hours are yet to be completed on a project by summing up the total outstanding quantity of items or hours on all project lines.
Data Sources
 Project Planning Line
## Purchase Line Measures
 #qty-on-purch-order
 #qty-on-purch-return
### Qty. on Purch. Order
Formula
 This measure shows how many items are yet to be received for purchase orders by summing up the outstanding quantity of items on all purchase order lines.
Data Sources
 Purchase Line
### Qty. on Purch. Return
Formula
 This measure shows how many items were returned to the supplier but are yet to be received or credited. It sums up the total outstanding quantity of items on all purchase return order lines.
Data Sources
 Purchase Line
## Sales Line Measures
 #qty-on-sales-order
 #qty-on-sales-return-order
### Qty. on Sales Order
Formula
 This measure shows how many items have been ordered by customers but are yet to be delivered or shipped. It sums up the total outstanding quantity of items on all sales order lines.
Data Sources
 Sales Line
### Qty. on Sales Return Order
Formula
 This measure shows how many items are yet to be returned by customers for sales return orders. It sums up the outstanding quantity of items on all sales lines that are associated with return orders.
Data Sources
 Sales Line
## Service Line Measures
 #qty-on-service-order
### Qty. on Service Order
Formula
 This measure represents how many service items or hours were ordered by customers but are yet to be fulfilled. It sums up the total outstanding quantity of items or hours on all service order lines.
Data Sources
 Service Line
## Transfer Line Measures
 #qty-in-transit
 #trans-order-outstanding-qty
 #trans-order-receipt-qty
 #trans-order-shipment-qty
### Qty. in Transit
Formula
 This measure shows how many items are currently in transit between locations. It sums up the quantity of items in transit on all transfer lines.
Data Sources
 Transfer Line
### Trans. Order Outstanding Qty.
Formula
 This measure calculates the total outstanding quantity for transfer orders. It sums up all values in the outstandingQtyBase column from the Transfer Lines table.
Data Sources
 Transfer Line
### Trans. Order Shipment (Qty.)
Formula
 This measure shows how many items were shipped between two locations. It sums up the total outstanding quantity of items on all transfer order lines that are associated with the specified location codes and shipment date.
Data Sources
 Transfer Line
### Trans. Order Receipt (Qty.)
Formula
 This measure shows how many items you expect to receive for transfer orders. It sums up the outstanding quantity of items on all transfer lines.
Data Sources
 Transfer Line
## ABC Classification Measures
 #no-of-items-in-class
 #percent-of-sales-amount
 #sales-amount-abc
 #sales-quantity-abc
### No. of Items in Class
Formula
 This measure returns the number of items based on the ABC classification. The ABC classification is determined by calculating the cumulated sales amount for an item, divided by the total sales amount for all items, to return the Cumulative Sales Amount Percent. Each item is assigned an ABC Classification based on whether the Cumulative Sales Amount Percent is within the lower and upper ABC class boundaries, as defined in the ABC Analysis Setup.
Data Sources
 Item Ledger Entry
### Percent of Sales Amount
Formula
 This measure returns the percentage share of total sales amount for a given ABC classification. It divides the #sales-amount-abc by the total sales amount across all selected items.
Data Sources
 Item Ledger Entry
### Sales Amount ABC
Formula
 This measure returns the #sales-amount-abc for each item based on the ABC classification. The ABC classification is determined by calculating the cumulated sales amount for an item, divided by the total sales amount for all items, to return the Cumulative Sales Amount Percent. Each item is assigned an ABC Classification based on whether the Cumulative Sales Amount Percent is within the lower and upper ABC class boundaries, as defined in the ABC Analysis Setup.
Data Sources
 Item Ledger Entry
### Sales Quantity ABC
Formula
 This measure returns the #sales-quantity-abc for each item based on the ABC classification. The ABC classification is determined by calculating the cumulated sales quantity for an item, divided by the total sales quantity for all items, to return the Cumulative Sales Quantity Percent. Each item is assigned an ABC Classification based on whether the Cumulative Sales Quantity Percent is within the lower and upper ABC class boundaries, as defined in the ABC Analysis Setup.
Data Sources
 Item Ledger Entry
## Related information
track-kpis-with-power-bi-metrics
Power BI Inventory app<inventory-powerbi-app>
Ad hoc analysis of inventory data<ad-hoc-analysis-inventory>
Built-in inventory and warehouse reports<inventory-wms-reports>
inventory-analytics-overview
Inventory overview<inventory-manage-inventory>
Find free e-learning modules for Business Central here<https://learn.microsoft.com/training/dynamics365/business-central>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-powerbi-kpis, MicrosoftDocs/dynamics365smb-docs at 46907ac (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/inventory-powerbi-kpis/
