VisibleRowsSet

Returns the set of all members which are visible on rows where each member is representing one row.

Syntax

CODE

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.

CODE

Avg(
  VisibleRowsSet(),
  [Measures].[Item base amount]
)