CUBESETCOUNT Function Explained
The CUBESETCOUNT Function in Microsoft Excel returns the number of cells in a Cube Set. A Cube Set is a set of cells that are defined by a MDX (Multi-Dimensional Expressions) statement. The CUBESETCOUNT Function takes two arguments: Set_Expression and Cube_Name. The Set_Expression argument is a MDX statement that defines the set of cells, and the Cube_Name argument is the name of the cube that contains the set of cells.
CUBESETCOUNT Function Syntax
CUBESETCOUNT(cube_name, set_expression)
- cube_name: The name of the cube to which the set belongs.
- set_expression: A set expression that defines the set.