count problem

#1

please help me..
i need to get the count of week.currentmember having > 0 value
i need this for my denominator in the mdx below:

SUM(week.CurrentMember.Children)/Count(week.CurrentMember.Children,EXCLUDEEMPTY)

#2

Assuming the > 0 value is for the current measure:

Count(Filter(Week.CurrentMember.Children,
[Measures].CurrentMember > 0))

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

#3

thanks deepak!

"Deepak Puri" wrote:

Quote:

Assuming the > 0 value is for the current measure:

Count(Filter(Week.CurrentMember.Children,
[Measures].CurrentMember > 0))

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

count problem

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

count problem - 07-22-2005 , 03:51 AM

Re: count problem - 07-22-2005 , 08:22 PM

Re: count problem - 07-28-2005 , 02:26 AM