Support center for flex.bi version 4.0
VisibleRowsSet
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]
)