Number of rows to return for each level
Table expression containing the columns used to define logical levels
Table containing rows defining the levels considering in the logical filter by level. Every row has 4 arguments: LevelNumber, TotalColumnName, ColumnName, FlagOrder
Table containing rows defining the items selected for each level. Every row has 4 arguments: Unknown, LevelNumber, ColumnName, ItemSelected
Table containing rows defining the boundaries for each level. Every row has 5 arguments: Unknown, LevelNumber, ColumnName, BoundaryItemValue, BoundaryType
Name of the column added to the result containing to indicate the presence of items before the row (1) or after the row (2).
The table returned is not sorted, it is just filtered according to the required parameters.
The sort order of the result depends on the ORDER BY condition of EVALUATE.
This is an undocumented extension function for Power BI that is not included in the Analysis Services engine.
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo