How do I count the current number of memebers. If I wanted
to count how many countires currently being displayed how
could I do that?

-mike

You want to count the # members in the query result? This involves the AXIS
function. Is it a given which axis (columns, rows, ?) the members will
appear on?

tom @ the domain below
www.tomchester.net


"Mike Morse" <mike.morse (AT) micromo (DOT) com> wrote

I may not be using the correct terminology but this seems
to be working

DistinctCount([Region].AllMembers)

So the farther down the region dim I go it is showing me
how many children there are at each level.

-mike

Hi Mike,

As I understand, it is hard to count how many countries currently being
displayed. We are only able to count how many countries being stored.

DistinctCount([Region].AllMembers) showed us the number of countries being
stored.

AllMembers returns a set containing all members of the specified dimension
or level, including calculated members.

DistinctCount returns the number of distinct, non-empty tuples in a set.

Did 'DistinctCount([Region].AllMembers)' meet your requirements. Please
feel free to post in the group if you would like further assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.