VisibleRowsSet
- Elvis Kvalbergs
- Gvido
Owned by Elvis Kvalbergs
Returns the set of all members which are visible on rows where each member is representing one row.
Syntax
VisibleRowsSet()
Arguments
n/a
Examples
The following formula would return average Item base amount created dynamically over the members for the dimension that is selected on rows - e.g. Average in filtered Time period or Average over selected Item group.
Avg( VisibleRowsSet(), [Measures].[Item base amount] )