• My second try is

    [Code]

    With MEMBER [Status].[Status].[All].[Inactive To Active] AS

    COUNT

    (

    NONEMPTY

    (

    NONEMPTY

    (

    [Member].[Member ID].[Member ID].MEMBERS,

    (

    [Status].[Status].&[Active], [Measures].[Member Count]

    )

    ),

    (

    [Measures].[Member Count],

    [Status].[Status].&[InActive],

    [Month].[Year Month Hierarchy].CurrentMember.PrevMember

    )

    )

    )

    select

    {

    [Status].[Status].[Inactive To Active]

    }

    on columns,

    {[Month].[Year Month Hierarchy].&[2015].&[2015Q1].&[201503]}

    on rows

    FROM [SnapshotCube]

    [/Code]

    The code returns (null).

    The code is basically the the same as my previous one. The only difference is that,

    the previous code adds the calculated member to the Measures dimension,

    this one adds the calculated member to the Status dimension Status Attribute.