DAX Measures – Open Sales Orders Data Model

Modified on Tue, 28 Jul at 2:07 PM

Measure Summary

This reference lists the DAX measures included in the prepared QQube Open Sales Orders examples for Power BI and Excel Power Pivot. The measures support original, invoiced, and open quantity and amount analysis by shipping period.

Data Model

Open Sales Orders

Reference Type

DAX measure reference

Visible Measures

Display Folders

Measure Names

Names are shown exactly as they appear in the model. Hidden measures are not included.

Base-measure visibility varies by data model.

The .Base Measures folder is visible in the current Open Sales Orders model and is included in this reference.

DAX formulas and methodology

For the calculation methods and supporting patterns used in QQube, see DAX Methods Used in PowerPivot and Power BI.

Measure Folders

The measures are grouped below by the same display folders used in Power BI and Excel Power Pivot.

.Base Measures (20 measures)
Calendar Pattern Measures (12 measures)
Open SO Quantity Measures (11 measures)

.Base Measures

Base calculations for original, invoiced, and open sales-order quantities, rates, and amounts.

Measure Name
.Line Invoiced [Actual Rate] Amount
.Line Invoiced [Actual Rate] Amount (Foreign)
.Line Invoiced [SO Rate] Amount
.Line Invoiced [SO Rate] Amount (Foreign)
.Line Invoiced Quantity
.Line Invoiced Quantity [Printed]
.Line Open [Actual Rate] Amount
.Line Open [Actual Rate] Amount (Foreign)
.Line Open [SO Rate] Amount
.Line Open [SO Rate] Amount (Foreign)
.Line Open Quantity
.Line Open Quantity [Printed]
.Line Original Amount
.Line Original Amount (Foreign)
.Line Original Quantity
.Line Original Quantity [Printed]
.Line Rate
.Line Rate (Foreign)
.Line Rate [Printed]
.Line Rate Percent

Back to Measure Folders

Calendar Pattern Measures

Cumulative open sales-order quantities and amounts by scheduled shipping week and month.

Measure Name
Open SO [Actual Rate] Amount (Foreign) - Cumulative by Shipping Month
Open SO [Actual Rate] Amount (Foreign) - Cumulative by Shipping Week
Open SO [Actual Rate] Amount - Cumulative by Shipping Month
Open SO [Actual Rate] Amount - Cumulative by Shipping Week
Open SO [SO Rate] Amount (Foreign) - Cumulative by Shipping Month
Open SO [SO Rate] Amount (Foreign) - Cumulative by Shipping Week
Open SO [SO Rate] Amount - Cumulative by Shipping Month
Open SO [SO Rate] Amount - Cumulative by Shipping Week
Open SO Quantity - Cumulative by Shipping Month
Open SO Quantity - Cumulative by Shipping Week
Open SO Quantity [Printed] - Cumulative by Shipping Month
Open SO Quantity [Printed] - Cumulative by Shipping Week

Back to Measure Folders

Open SO Quantity Measures

Open sales-order quantities for current and upcoming shipping periods.

Measure Name
Quantity Open - Shipping Current Month
Quantity Open - Shipping Current Quarter
Quantity Open - Shipping Current Week
Quantity Open - Shipping Current Year
Quantity Open - Shipping Next Month
Quantity Open - Shipping Next Quarter
Quantity Open - Shipping Next Two Weeks
Quantity Open - Shipping Next Week
Quantity Open - Shipping Next Year
Quantity Open - Shipping Today
Quantity Open - Shipping Tomorrow

Back to Measure Folders