In this article
CUBESETCOUNT counts the items in a set made with CUBESET. Cube functions read from a Power Pivot Data Model (connection “ThisWorkbookDataModel”) or an Analysis Services cube.
Advertisement
Syntax
=CUBESETCOUNT(set)| Argument | What it means |
|---|---|
connection |
“ThisWorkbookDataModel” for Power Pivot |
… |
Member, set or KPI expressions in MDX form |
Examples
Example 1
=CUBESETCOUNT(set)Result: (value from your Data Model). See the worked example table below for more cases.
CUBESETCOUNT in practice
Where you will use it
- Custom report layouts that PivotTables can't do
- Top-N lists with CUBESET + CUBERANKEDMEMBER
- Finance packs from a data model
Worked example
| Workbook | Formula | Result |
|---|---|---|
| Has a Data Model | =CUBESETCOUNT(set) | (value from your Data Model) |
Needs a Power Pivot Data Model, so this example is not calculated here: the result is whatever your model holds.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Typos in member names | Build them with PivotTable > OLAP Tools > Convert to Formulas |
| No data model | #N/A or #NAME? |
Related functions
CUBEVALUE · CUBESET · CUBEMEMBER
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong