0

Hi, I'm having trouble to filter a Customer Set by the date of his first buy(First Activity).

I've tried this two ways:

  1. Returns all customers, even with FirstActivity Null

    SELECT {
    [Measures].[Valor Item],
    [Measures].[First Activity]
    } ON 0,
    {
    Filter(
    { [CLIENTE].[Cliente].[Cliente].Members },
    ( [Measures].[First Activity], [Time].[Year].&[2012-01-01T00:00:00] ).Count > 2
    )
    } ON 1
    FROM
    [SCA]

  2. Return customers that FirstActivity is not null but is outside the Year specified(In this case 2012).

    SELECT {
    [Measures].[Valor Item],
    [Measures].[First Activity]
    } ON 0,
    {
    NonEmpty(
    { [CLIENTE].[Cliente].[Cliente].Members },
    ( [Measures].[First Activity], [Time].[Year].&[2012-01-01T00:00:00] )
    )
    } ON 1
    FROM
    [SCA]

Any help is appreciated.
Thanks.

1
Contributor
1
Reply
2
Views
4 Years
Discussion Span
Last Post by AleMonteiro
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.