• I think you are asking for the same rows values as the first query, without all the NULLs. The NON EMPTY instruction any row that contains at least 1 non null column. In you case the address line 1 fits that criteria so all customers are now valid.

    If you change to use the NONEMPTY function instead then you can target a measure when checking for NONEMPTY values as below:

    with member [Measures].AddressLine1

    as [Customer].[Customer].Properties( "Address Line 1" )

    select {[Measures].[Net Value],[Measures].AddressLine1} on 0,

    NONEMPTY ([Customer].[Customer].[Customer].Members,

    [Measures].[Net Value]) on 1

    from (select (

    [Transaction Date].[Date].&[2013-01-25T00:00:00]

    ) on 0 from [Invoice And Credits])

    Fitz