VisibleColumnsSet
EAZYBI Returns the set of all members, which are visible in columns where each member represents one column.
This function uses report visible members only and will not return expected results when drilling into details. We recommend disabling drill actions with special annotations comments.
Syntax
VisibleColumnsSet()
Arguments
n/a
Examples
The following formula would return average issues created dynamically over the members for the dimension that is selected on columns - e.g. Average in filtered Time period or Average over selected Projects.
-- annotations.disable_drill=true Avg( VisibleColumnsSet(), [Measures].[Issues created] )
See also
- Adding standard calculations based on selected measures.
- VisibleRowsSet
- Training video Flexible Custom Formulas: How to Use VisibleRows and VisibleColumns