Hi,

i have a calculated member:

[Measures].[Available]/Count({descendants([Unit].Currentmember,[Unit].[Unit
Name])})

This one devides the value 'Available' by the number of Units. Example:
[Measures].[Available]
UnitA 4
UnitB 4
UnitC
UnitD 4

On roll up on 'All Units' this formulas returns the value 3. In the division
UnitC is also counted for the division even when it's empty. Now i am trying
to look for one of the built in function to filter this empty Unit, so that
the result will be 4 instead of 3. However i can't find the non empty
function within the MDX sample application. Is there a way to filter this
empty Unit?

Thnx,

Stanley

One way is to use Filter() with IsEmpty():

Descendants([Unit].Currentmember,
[Unit].[Unit Name]),
NOT IsEmpty([Measures].[Available])))

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thnx Deepak,

It worked.

- Stanley

"Deepak Puri" wrote: