Hi all. It's been a long time since I have had my hands in SSAS. Basically, what I am trying to do is compute the average of a measure filtering out values that are NULL. Can someone post the MDX to do that?

Thanks.

Sorry for resurrecting an old topic, but it's got the exact subject I would have used.

I'd like to create a Calculated Member using the AVG() function, but I can't work out what to supply as the <<Set>> argument.  What's the correct way to express

AVG( {TheCurrentScope}, [Measures].[Value To Average That Might Have NULL Values] )