DAX Measures – Accounts Receivable Data Model

Modified on Tue, 28 Jul at 2:18 PM

Measure Summary

This reference lists the DAX measures included in the prepared QQube Accounts Receivable examples for Power BI and Excel Power Pivot. The measures support open balances, applied amounts, aging, payment terms, and cumulative receivable analysis.

Data Model

Accounts Receivable

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.

Power BI company-filter measures

The three measures without a display folder support the Account, Class, and Customer bridge tables used in Power BI. They limit each slicer to values associated with the selected company. Excel Power Pivot handles this filtering automatically and does not require the same bridge-table logic.

DAX formulas and methodology

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

Measure Sections

The measures are grouped below according to their placement in Power BI and Excel Power Pivot.

Measures Without a Display Folder (3 measures)
.Base Measures (22 measures)
Average Days Measures (2 measures)
Calendar Pattern Measures (4 measures)

Measures Without a Display Folder

Power BI support measures that keep the Account, Class, and Customer slicers limited to values associated with the selected company. Excel Power Pivot handles this filtering automatically.

Measure Name
Account Slicer: Company Filter
Class Slicer: Company Filter
Customer Slicer: Company Filter

Back to Measure Sections

.Base Measures

Base calculations for original, applied, and open accounts receivable amounts, rates, quantities, exchange rates, and aging buckets.

Measure Name
.Due Date Aging Bucket1
.Due Date Aging Bucket2
.Due Date Aging Bucket3
.Due Date Aging Bucket4
.Due Date Aging Current
.Line Applied To A/R Amount
.Line Applied To A/R Amount (Foreign)
.Line Exchange Rate
.Line Open A/R Amount
.Line Open A/R Amount (Foreign)
.Line Original Amount
.Line Original Amount (Foreign)
.Line Quantity
.Line Quantity [Printed[
.Line Rate
.Line Rate [Printed]
.Line Rate Percent
.Txn Date Aging Bucket1
.Txn Date Aging Bucket2
.Txn Date Aging Bucket3
.Txn Date Aging Bucket4
.Txn Date Aging Current

Back to Measure Sections

Average Days Measures

Measures for average payment terms and average days aged past the due date.

Measure Name
Average Days Aged Past Due Date
Average Days For Terms

Back to Measure Sections

Calendar Pattern Measures

Cumulative original and outstanding accounts receivable amounts by week and month.

Measure Name
AR Amount Due - Cumulative by Month
AR Amount Due - Cumulative by Week
AR Amount Original - Cumulative by Month
AR Amount Original - Cumulative by Week

Back to Measure Sections