DAX Base Measure

Modified on Sat, 29 Jun at 2:39 AM

Overview

These measures all begin with a "." and are default SUM calculations on raw QQube fields.

A QQube FACT table contains the following measurable field categories:

Count
Amount
Quantity
Line Rate
Line Exchange Rate

Count is an integer of 1 for each line and can also be found in some dimensions

Count, Amount, Quantity have the default of SUM assigned to the calculation.

Line Rate and Exchange Rate cannot have an AVG assigned to the calculation and work properly. In these cases, it is necessary to divide amount measures by quantity measures to get a rate which is dynamically accurate.

Examples

.Line Sales Amount =
SUM ( 'SALES VALUES'[Line Sales Amount] )

.Line Rate =
DIVIDE (
SUMX ( 'SALES VALUES', 'SALES VALUES'[.Line Sales Amount] ),
'SALES VALUES'[.Line Sales Quantity]
)

Usage

There are no filters - just a raw SUM (or DIVIDE for a Rate Field). These can be used anytime you need a complete FACT table value. Other measures in the data models stop at today's date, as defined in the QQube Configuration Tool.

Flexible Period Financial Statement Variations

There are two categories of .Base Measures in these data models:

.Base Measures
.Base Measures For Hierarchies

QQube has specific account dimensions to handle ragged hierarchies in financial statements and are implemented within the measures that exist in the .Base Measure for Hierarchies category. The Measures in the .Base Measures category are there if anybody desires not to use the hierarchies we have created.

.Actual =
SUM ( 'PROFIT AND LOSS MEASURES'[Actual Amount] )
* MAX ( 'Account'[Sign to Apply] )

.Hierarchy Actual =
VAR ProfitAndLossActual =
  SUM ( 'PROFIT AND LOSS MEASURES'[Actual Amount] )
  * MAX ( 'Account'[Sign To Apply] )
RETURN
  VAR AccountBrowseDepth = [[DAXP]] AccountBrowseDepth]
  VAR AccountRowDepth = [[DAXP]] AccountRowDepth]
  VAR _IsLeaf =
  IF (
      HASONEVALUE ( Account[Account Has Children] ),
      VALUES ( Account[Account Has Children] )
  )
  VAR Result =
  SWITCH (
      TRUE (),
      AccountBrowseDepth = AccountRowDepth + 1
      && NOT ( ISBLANK ( ProfitAndLossActual ) )
          && _IsLeaf = TRUE (), ProfitAndLossActual,
      AccountBrowseDepth <= AccountRowDepth, ProfitAndLossActual
  )
  RETURN
  Result