locked
How to find Count of Nulls in a Column in MDX RRS feed

  • Question

  • Hi,

    Iam having a dimension in which one of the attribute is having null values.

    Need to get count of nulls as a measure..

    Help me

    Wednesday, October 19, 2011 4:17 PM

Answers

  • I have gone with a named query in my DSV by getting null count.

    Is this good practice??

     

    Monday, October 24, 2011 10:10 AM

All replies

  • COUNT ( FILTER ( [Dimension].[Level].Members, IsEmpty( [Dimension].CurrentMember)))
    
    

    Substitute the dimension and attributes with the ones you have in your cube.


    http://dailyitsolutions.blogspot.com/
    • Edited by Umair.Khan Wednesday, October 19, 2011 7:28 PM
    Wednesday, October 19, 2011 7:28 PM
  • Iam Getting ZERO with this.

    I added that to a calculated member in mycube its not working

    Monday, October 24, 2011 9:42 AM
  • I have gone with a named query in my DSV by getting null count.

    Is this good practice??

     

    Monday, October 24, 2011 10:10 AM