These start with [DAXP and are hidden. Their purpose is to perform functions to handle ragged hierarchies in financial statement groupings and account levels.
For instance if you drill down on a level 1 account, and some of those have sub-accounts at level 2 or greater, you won't get blank rows where there are NOT level 2 or greater sub-accounts.
These negate the need for a mechanism such as used in our Excel Add-In - the Presentation Cleanup.
They are used in the following Data Models:
There are two formulas:
Both of these measure are used in this ".Hierarchy Actual" Formula in the Flexible Period Profit and Loss Data Model
.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/6132/hierarchy-measures
Your session has expired. You are being logged out.