Measure Summary
This reference lists the DAX measures included in the prepared QQube Sales examples for Power BI and Excel Power Pivot. The measures support sales amount, quantity, cost of goods sold, profit margin, customer activity, open sales order, and calendar analysis.
Data Model Sales | Reference Type DAX measure reference |
Visible Measures 368 | Display Folders 8 |
Measure Names Names are shown exactly as they appear in the model. Measures marked as hidden are not included. | |
Base-measure visibility varies by data model.
The .Base Measures folder is visible in the current Sales model and is included in this reference. Other data-model references will include only the folders and measures visible in those models.
DAX formulas and methodology: For an explanation of the DAX methods, measure categories, and supporting calculation patterns used in QQube, see DAX Methods Used in Power Pivot 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 (40 measures)
- Calendar Pattern Measures (101 measures)
- COGS Measures (47 measures)
- Customer Measures (27 measures)
- Open SO Measures (11 measures)
- Profit Margin Measures (47 measures)
- Sales Amount Measures (47 measures)
- Sales Quantity Measures (48 measures)
.Base Measures
Unfiltered base calculations built from the measurable Sales FACT fields. These measures support custom analysis and other customer-facing calculations.
| Measure Name |
|---|
| .Line COGS Amount |
| .Line COGS Amount (Foreign) |
| .Line Credit Memo Applied to Document |
| .Line Credits Applied On Document |
| .Line Discounts Applied On Document |
| .Line Discounts Applied To Document |
| .Line Estimate Cost Amount |
| .Line Estimate Cost Amount (Foreign) |
| .Line Estimate Income Amount |
| .Line Estimate Income Amount (Foreign) |
| .Line Estimate Markup Amount |
| .Line Estimate Markup Percent |
| .Line Estimate Quantity |
| .Line Exchange Rate |
| .Line Payments Applied On Document |
| .Line Payments Applied To Document |
| .Line Rate |
| .Line Rate (Foreign) |
| .Line Rate [Printed] |
| .Line Rate Percent |
| .Line Sales Amount |
| .Line Sales Amount (Foreign) |
| .Line Sales Applied Amount |
| .Line Sales Open Amount |
| .Line Sales Profit Margin Amount |
| .Line Sales Profit Margin Amount (Foreign) |
| .Line Sales Quantity |
| .Line Sales Quantity [Printed] |
| .Line SO Initial Invoiced Quantity |
| .Line SO Invoiced [Actual Rate] Amount |
| .Line SO Invoiced [SO Rate] Amount |
| .Line SO Invoiced Quantity |
| .Line SO Invoiced Quantity [Printed] |
| .Line SO Open [Actual Rate] Amount |
| .Line SO Open [SO Rate] Amount |
| .Line SO Open Quantity |
| .Line SO Open Quantity [Printed] |
| .Line SO Original Amount |
| .Line SO Original Quantity |
| .Line SO Original Quantity [Printed] |
Calendar Pattern Measures
Cumulative week, month, quarter, and year measures for time-series visuals, period comparisons, and growth analysis.
| Measure Name |
|---|
| Applied Credit Memo Amount - Cumulative by Month |
| Applied Credit Memo Amount - Cumulative by Quarter |
| Applied Credit Memo Amount - Cumulative by Week |
| Applied Credit Memo Amount - Cumulative by Year |
| COGS Amount - Cumulative by Month |
| COGS Amount - Cumulative by Quarter |
| COGS Amount - Cumulative by Week |
| COGS Amount - Cumulative by Year |
| Customers (New) - Cumulative by Month |
| Customers (New) - Cumulative by Month PM |
| Customers (New) - Cumulative by Quarter |
| Customers (New) - Cumulative by Quarter PQ |
| Customers (New) - Cumulative by Year |
| Customers (New) - Cumulative by Year PY |
| Customers (New) - MOM % |
| Customers (New) - QOQ % |
| Customers (New) - YOY % |
| Discounts Applied On Document - Cumulative by Month |
| Discounts Applied On Document - Cumulative by Quarter |
| Discounts Applied On Document - Cumulative by Week |
| Discounts Applied On Document - Cumulative by Year |
| Discounts Applied Via Early Payment - Cumulative by Month |
| Discounts Applied Via Early Payment - Cumulative by Quarter |
| Discounts Applied Via Early Payment - Cumulative by Week |
| Discounts Applied Via Early Payment - Cumulative by Year |
| Fulfillment Rate - by Month |
| Fulfillment Rate - by Quarter |
| Fulfillment Rate - by Week |
| Fulfillment Rate - by Year |
| Margin % - Average by Month |
| Margin % - Average by Quarter |
| Margin % - Average by Week |
| Margin % - Average by Year |
| Markup % - Average by Month |
| Markup % - Average by Quarter |
| Markup % - Average by Week |
| Markup % - Average by Year |
| Sales Amount - Cumulative by [Fully Paid] Month |
| Sales Amount - Cumulative by [Fully Paid] Quarter |
| Sales Amount - Cumulative by [Fully Paid] Week |
| Sales Amount - Cumulative by [Fully Paid] Year |
| Sales Amount - Cumulative by [Service Date] Month |
| Sales Amount - Cumulative by [Service Date] Quarter |
| Sales Amount - Cumulative by [Service Date] Week |
| Sales Amount - Cumulative by [Service Date] Year |
| Sales Amount - Cumulative by Month |
| Sales Amount - Cumulative by Month PM |
| Sales Amount - Cumulative by Quarter |
| Sales Amount - Cumulative by Quarter PQ |
| Sales Amount - Cumulative by Week |
| Sales Amount - Cumulative by Year |
| Sales Amount - Cumulative by Year PY |
| Sales Amount - MOM % |
| Sales Amount - QOQ % |
| Sales Amount - YOY % |
| Sales Amount (Foreign) - Cumulative by Month |
| Sales Amount (Foreign) - Cumulative by Quarter |
| Sales Amount (Foreign) - Cumulative by Week |
| Sales Amount (Foreign) - Cumulative by Year |
| Sales Exchange Rate by Month |
| Sales Exchange Rate by Quarter |
| Sales Exchange Rate by Week |
| Sales Exchange Rate by Year |
| Sales Open Amount [Current] - Cumulative by Month |
| Sales Open Amount [Current] - Cumulative by Quarter |
| Sales Open Amount [Current] - Cumulative by Week |
| Sales Open Amount [Current] - Cumulative by Year |
| Sales Profit Margin Amount - Cumulative by Month |
| Sales Profit Margin Amount - Cumulative by Quarter |
| Sales Profit Margin Amount - Cumulative by Week |
| Sales Profit Margin Amount - Cumulative by Year |
| Sales Quantity - Cumulative by [Service Date] Month |
| Sales Quantity - Cumulative by [Service Date] Quarter |
| Sales Quantity - Cumulative by [Service Date] Week |
| Sales Quantity - Cumulative by [Service Date] Year |
| Sales Quantity - Cumulative by Month |
| Sales Quantity - Cumulative by Month PM |
| Sales Quantity - Cumulative by Quarter |
| Sales Quantity - Cumulative by Quarter PQ |
| Sales Quantity - Cumulative by Week |
| Sales Quantity - Cumulative by Year |
| Sales Quantity - Cumulative by Year PY |
| Sales Quantity - MOM % |
| Sales Quantity - QOQ % |
| Sales Quantity - YOY % |
| SO Initial Invoiced Quantity - Cumulative by Month |
| SO Initial Invoiced Quantity - Cumulative by Quarter |
| SO Initial Invoiced Quantity - Cumulative by Week |
| SO Initial Invoiced Quantity - Cumulative by Year |
| SO Open [Actual Rate] Amount - Cumulative by Shipping Month |
| SO Open [Actual Rate] Amount - Cumulative by Shipping Week |
| SO Open [SO Rate] Amount - Cumulative by Shipping Month |
| SO Open [SO Rate] Amount - Cumulative by Shipping Week |
| SO Open Quantity - Cumulative by Shipping Month |
| SO Open Quantity - Cumulative by Shipping Week |
| SO Open Quantity [Printed] - Cumulative by Shipping Month |
| SO Open Quantity [Printed] - Cumulative by Shipping Week |
| SO Original Quantity - Cumulative by Month |
| SO Original Quantity - Cumulative by Quarter |
| SO Original Quantity - Cumulative by Week |
| SO Original Quantity - Cumulative by Year |
COGS Measures
Cost of goods sold measures for current, prior, to-date, and comparative reporting periods.
| Measure Name |
|---|
| COGS - Compare Current Month vs Previous Year Month |
| COGS - Compare Current Month vs Previous Year Month % |
| COGS - Compare Current MTD vs Previous Year MTD |
| COGS - Compare Current MTD vs. Previous Year MTD % |
| COGS - Compare Current QTD vs Last QTD |
| COGS - Compare Current QTD vs Last QTD % |
| COGS - Compare Current QTD vs Previous Year QTD |
| COGS - Compare Current QTD vs Previous Year QTD % |
| COGS - Compare Current Quarter vs Previous Year Quarter |
| COGS - Compare Current Quarter vs Previous Year Quarter % |
| COGS - Compare Current WTD vs Last WTD |
| COGS - Compare Current WTD vs Last WTD % |
| COGS - Compare Current Year-to-Last Month vs Previous Year-to-Last Month |
| COGS - Compare Current Year-to-Last Month vs Previous Year-to-Last Month % |
| COGS - Compare Current YTD vs Previous YTD |
| COGS - Compare Current YTD vs Previous YTD % |
| COGS - Compare Last Month vs Previous Year Last Month |
| COGS - Compare Last Month vs Previous Year Last Month % |
| COGS - Compare Last Quarter vs Previous Year Last Quarter |
| COGS - Compare Last Quarter vs Previous Year Last Quarter % |
| COGS - Current Month |
| COGS - Current Month-to-Date |
| COGS - Current Quarter |
| COGS - Current Quarter-to-Date |
| COGS - Current Week |
| COGS - Current Week-to-Date |
| COGS - Current Year |
| COGS - Current Year-to-Date |
| COGS - Current Year-to-Last Month |
| COGS - Last Month |
| COGS - Last Month-to-Date |
| COGS - Last Quarter |
| COGS - Last Quarter-to-Date |
| COGS - Last Week |
| COGS - Last Week-to-Date |
| COGS - Previous Year |
| COGS - Previous Year Last Month |
| COGS - Previous Year Last Quarter |
| COGS - Previous Year Month |
| COGS - Previous Year Month-to-Date |
| COGS - Previous Year Quarter |
| COGS - Previous Year Quarter-to-Date |
| COGS - Previous Year-to-Date |
| COGS - Previous Year-to-Last Month |
| COGS - Today |
| COGS - Tomorrow |
| COGS - Yesterday |
Customer Measures
Customer counts, new-customer activity, purchase history, transaction values, and customer lifetime measures.
| Measure Name |
|---|
| Customer - Average Sales Amount |
| Customer - Average Sales Quantity |
| Customer - Days Since Last Purchase |
| Customer - First Sales Transaction Amount |
| Customer - First Sales Transaction Date |
| Customer - Last Sales Transaction Amount |
| Customer - Last Sales Transaction Date |
| Customer - Lifetime Value |
| Customer - Sales Transaction Count |
| Customer Count (All) |
| Customer Count (New) |
| Customer Count (New) - Current Month-to-Date |
| Customer Count (New) - Current Quarter-to-Date |
| Customer Count (New) - Current Week-to-Date |
| Customer Count (New) - Current Year-to-Date |
| Customer Count (New) - Current Year-to-Last Month |
| Customer Count (New) - Last Month |
| Customer Count (New) - Last Month-to-Date |
| Customer Count (New) - Last Quarter |
| Customer Count (New) - Last Quarter-to-Date |
| Customer Count (New) - Last Week |
| Customer Count (New) - Previous Year |
| Customer Count (New) - Previous Year Month-to-Date |
| Customer Count (New) - Previous Year Quarter-to-Date |
| Customer Count (New) - Previous Year-to-Date |
| Customer Count (New) - Today |
| Customer Count (New) - Yesterday |
Open SO Measures
Open sales order quantity measures organized by scheduled shipping periods.
| Measure Name |
|---|
| Quantity Open SO - Shipping Current Month |
| Quantity Open SO - Shipping Current Quarter |
| Quantity Open SO - Shipping Current Week |
| Quantity Open SO - Shipping Current Year |
| Quantity Open SO - Shipping Next Month |
| Quantity Open SO - Shipping Next Quarter |
| Quantity Open SO - Shipping Next Two Weeks |
| Quantity Open SO - Shipping Next Week |
| Quantity Open SO - Shipping Next Year |
| Quantity Open SO - Shipping Today |
| Quantity Open SO - Shipping Tomorrow |
Profit Margin Measures
Profit margin measures for current, prior, to-date, and comparative reporting periods.
| Measure Name |
|---|
| Profit Margin - Compare Current Month vs Previous Year Month |
| Profit Margin - Compare Current Month vs Previous Year Month % |
| Profit Margin - Compare Current MTD vs Previous Year MTD |
| Profit Margin - Compare Current MTD vs. Previous Year MTD % |
| Profit Margin - Compare Current QTD vs Last QTD |
| Profit Margin - Compare Current QTD vs Last QTD % |
| Profit Margin - Compare Current QTD vs Previous Year QTD |
| Profit Margin - Compare Current QTD vs Previous Year QTD % |
| Profit Margin - Compare Current Quarter vs Previous Year Quarter |
| Profit Margin - Compare Current Quarter vs Previous Year Quarter % |
| Profit Margin - Compare Current WTD vs Last WTD |
| Profit Margin - Compare Current WTD vs Last WTD % |
| Profit Margin - Compare Current Year-to-Last Month vs Previous Year-to-Last Month |
| Profit Margin - Compare Current Year-to-Last Month vs Previous Year-to-Last Month % |
| Profit Margin - Compare Current YTD vs Previous YTD |
| Profit Margin - Compare Current YTD vs Previous YTD % |
| Profit Margin - Compare Last Month vs Previous Year Last Month |
| Profit Margin - Compare Last Month vs Previous Year Last Month % |
| Profit Margin - Compare Last Quarter vs Previous Year Last Quarter |
| Profit Margin - Compare Last Quarter vs Previous Year Last Quarter % |
| Profit Margin - Current Month |
| Profit Margin - Current Month-to-Date |
| Profit Margin - Current Quarter |
| Profit Margin - Current Quarter-to-Date |
| Profit Margin - Current Week |
| Profit Margin - Current Week-to-Date |
| Profit Margin - Current Year |
| Profit Margin - Current Year-to-Date |
| Profit Margin - Current Year-to-Last Month |
| Profit Margin - Last Month |
| Profit Margin - Last Month-to-Date |
| Profit Margin - Last Quarter |
| Profit Margin - Last Quarter-to-Date |
| Profit Margin - Last Week |
| Profit Margin - Last Week-to-Date |
| Profit Margin - Previous Year |
| Profit Margin - Previous Year Last Month |
| Profit Margin - Previous Year Last Quarter |
| Profit Margin - Previous Year Month |
| Profit Margin - Previous Year Month-to-Date |
| Profit Margin - Previous Year Quarter |
| Profit Margin - Previous Year Quarter-to-Date |
| Profit Margin - Previous Year-to-Date |
| Profit Margin - Previous Year-to-Last Month |
| Profit Margin - Today |
| Profit Margin - Tomorrow |
| Profit Margin - Yesterday |
Sales Amount Measures
Sales amount measures for current, prior, to-date, and comparative reporting periods.
| Measure Name |
|---|
| Amount Sold - Compare Current Month vs Previous Year Month |
| Amount Sold - Compare Current Month vs Previous Year Month % |
| Amount Sold - Compare Current MTD vs Previous Year MTD |
| Amount Sold - Compare Current MTD vs. Previous Year MTD % |
| Amount Sold - Compare Current QTD vs Last QTD |
| Amount Sold - Compare Current QTD vs Last QTD % |
| Amount Sold - Compare Current QTD vs Previous Year QTD |
| Amount Sold - Compare Current QTD vs Previous Year QTD % |
| Amount Sold - Compare Current Quarter vs Previous Year Quarter |
| Amount Sold - Compare Current Quarter vs Previous Year Quarter % |
| Amount Sold - Compare Current WTD vs Last WTD |
| Amount Sold - Compare Current WTD vs Last WTD % |
| Amount Sold - Compare Current Year-to-Last Month vs Previous Year-to-Last Month |
| Amount Sold - Compare Current Year-to-Last Month vs Previous Year-to-Last Month % |
| Amount Sold - Compare Current YTD vs Previous YTD |
| Amount Sold - Compare Current YTD vs Previous YTD % |
| Amount Sold - Compare Last Month vs Previous Year Last Month |
| Amount Sold - Compare Last Month vs Previous Year Last Month % |
| Amount Sold - Compare Last Quarter vs Previous Year Last Quarter |
| Amount Sold - Compare Last Quarter vs Previous Year Last Quarter % |
| Amount Sold - Current Month |
| Amount Sold - Current Month-to-Date |
| Amount Sold - Current Quarter |
| Amount Sold - Current Quarter-to-Date |
| Amount Sold - Current Week |
| Amount Sold - Current Week-to-Date |
| Amount Sold - Current Year |
| Amount Sold - Current Year-to-Date |
| Amount Sold - Current Year-to-Last Month |
| Amount Sold - Last Month |
| Amount Sold - Last Month-to-Date |
| Amount Sold - Last Quarter |
| Amount Sold - Last Quarter-to-Date |
| Amount Sold - Last Week |
| Amount Sold - Last Week-to-Date |
| Amount Sold - Previous Year |
| Amount Sold - Previous Year Last Month |
| Amount Sold - Previous Year Last Quarter |
| Amount Sold - Previous Year Month |
| Amount Sold - Previous Year Month-to-Date |
| Amount Sold - Previous Year Quarter |
| Amount Sold - Previous Year Quarter-to-Date |
| Amount Sold - Previous Year-to-Date |
| Amount Sold - Previous Year-to-Last Month |
| Amount Sold - Today |
| Amount Sold - Tomorrow |
| Amount Sold - Yesterday |
Sales Quantity Measures
Sales quantity measures for current, prior, to-date, comparative, and fulfillment reporting.
| Measure Name |
|---|
| Quantity - Fulfillment Rate |
| Quantity Sold - Compare Current Month vs Previous Year Month |
| Quantity Sold - Compare Current Month vs Previous Year Month % |
| Quantity Sold - Compare Current MTD vs Previous Year MTD |
| Quantity Sold - Compare Current MTD vs. Previous Year MTD % |
| Quantity Sold - Compare Current QTD vs Last QTD |
| Quantity Sold - Compare Current QTD vs Last QTD % |
| Quantity Sold - Compare Current QTD vs Previous Year QTD |
| Quantity Sold - Compare Current QTD vs Previous Year QTD % |
| Quantity Sold - Compare Current Quarter vs Previous Year Quarter |
| Quantity Sold - Compare Current Quarter vs Previous Year Quarter % |
| Quantity Sold - Compare Current WTD vs Last WTD |
| Quantity Sold - Compare Current WTD vs Last WTD % |
| Quantity Sold - Compare Current Year-to-Last Month vs Previous Year-to-Last Month |
| Quantity Sold - Compare Current Year-to-Last Month vs Previous Year-to-Last Month % |
| Quantity Sold - Compare Current YTD vs Previous YTD |
| Quantity Sold - Compare Current YTD vs Previous YTD % |
| Quantity Sold - Compare Last Month vs Previous Year Last Month |
| Quantity Sold - Compare Last Month vs Previous Year Last Month % |
| Quantity Sold - Compare Last Quarter vs Previous Year Last Quarter |
| Quantity Sold - Compare Last Quarter vs Previous Year Last Quarter % |
| Quantity Sold - Current Month |
| Quantity Sold - Current Month-to-Date |
| Quantity Sold - Current Quarter |
| Quantity Sold - Current Quarter-to-Date |
| Quantity Sold - Current Week |
| Quantity Sold - Current Week-to-Date |
| Quantity Sold - Current Year |
| Quantity Sold - Current Year-to-Date |
| Quantity Sold - Current Year-to-Last Month |
| Quantity Sold - Last Month |
| Quantity Sold - Last Month-to-Date |
| Quantity Sold - Last Quarter |
| Quantity Sold - Last Quarter-to-Date |
| Quantity Sold - Last Week |
| Quantity Sold - Last Week-to-Date |
| Quantity Sold - Previous Year |
| Quantity Sold - Previous Year Last Month |
| Quantity Sold - Previous Year Last Quarter |
| Quantity Sold - Previous Year Month |
| Quantity Sold - Previous Year Month-to-Date |
| Quantity Sold - Previous Year Quarter |
| Quantity Sold - Previous Year Quarter-to-Date |
| Quantity Sold - Previous Year-to-Date |
| Quantity Sold - Previous Year-to-Last Month |
| Quantity Sold - Today |
| Quantity Sold - Tomorrow |
| Quantity Sold - Yesterday |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article