TOPNPERLEVEL DAX Function (Table manipulation)
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Rows |
Number of rows to return for each level |
|
| Table |
Table expression containing the columns used to define logical levels |
|
| LevelsDefinition |
Table containing rows defining the levels considering in the logical filter by level. Every row has 4 arguments: LevelNumber, TotalColumnName, ColumnName, FlagOrder |
|
| NodesExpanded |
Table containing rows defining the items selected for each level. Every row has 4 arguments: Unknown, LevelNumber, ColumnName, ItemSelected |
|
| LevelsBoundaries |
Table containing rows defining the boundaries for each level. Every row has 5 arguments: Unknown, LevelNumber, ColumnName, BoundaryItemValue, BoundaryType |
|
| RestartIndicatorColumnName |
Name of the column added to the result containing to indicate the presence of items before the row (1) or after the row (2). |
Return values
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.
Remarks
This is an undocumented extension function for Power BI that is not included in the Analysis Services engine.
Related functions
Other related functions are:
Last update: Feb 18, 2020 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation not available.
The function may be undocumented or unsupported. Check the Compatibility box on this page.