locked
calculate number of rows - MDX RRS feed

  • Question

  •  

    using following expression

     

    COUNT( NONEMPTY( ancestor([Date].[Fiscal].CurrentMember,[Date].[Fiscal].[Month]).Children ,[Measures].[My Measure]))

     

    I can calculate not null values , but if they are = 0 , I still calculate the number of rows with 0 . I want to be able to calculate only not null and <> 0 rows

    Any suggestions ?

    Thanks in advance

     


     

    Monday, April 21, 2008 6:57 AM

Answers

All replies