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 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.
.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])
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.
There are two categories of .Base Measures in these data models:
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
Please enable JavaScript to use file uploader.
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/6126/-base-measures
Your session has expired. You are being logged out.