Hello. I’m new to Analysis Services and OLAP. I have a simple issue that seems rather complex to me in how to solve

I have a table that contains a few columns of data, here’s an example of my problem column

Column
-------
2
2
2
2
2
2

What I am trying to figure out is how to use the COUNT function to count how many times “23” occurs

Any help would be greatly appreciated!

MDX Count() counts how many items in a set. If you insist to use Count(), you have to build a dimension which groups all 23 item under parent 23 grouping, etc

Then define custom rollup formula on 23 grouping as Count

The simple approach will be to build a table in relational database(pre-solving the count

Number Howman
23 1
24 1

Thank you for your help. I understand everything up until this

"define custom rollup formula on 23 grouping as Count

Can you give me an example? Thanks again.

On number grouping level (including 23 grouping), define custom roll-up formula as
Count([dim].currentmember.children)