Filter Set by another Set

Question

I want to filter a set by another set, which is returned by the event @{date}. The following code only works if the @{date} event returns a single member (e.g. [TIME_DIMENSION].[YEAR].[2010]). Any suggestions how to filter if the event returns more than one member?

WITH SET [A] AS
    Filter(
        TopPercent(
            [PRODUCTS].members - [PRODUCTS].[all],
            80,
            [Measures].[Sales]
        ),
        @{date}
    )

Can you describe what do you want to achieve by the Filter function ? you want to remove from the top80 products the ones that are empty ? — ic3, Jul 12 '16 at 10:17
I want to keep from the top80 products the ones that have a sales number on the dates specified by the `@{date}` event. — Christian Welsch, Jul 12 '16 at 10:31

score 1 · Accepted Answer · edited Jul 12 '16 at 12:36

1

Maybe you could use the NonEmpty function? It would return the set of non empty tuples from the set.

WITH SET [A] AS
NonEmpty(    
        TopPercent(
            [PRODUCTS].members - [PRODUCTS].[all],
            80,
            [Measures].[Sales]
        )
    ,@{date} * [Measures].[Sales]
       )

edited Jul 12 '16 at 12:36

ic3

7,917
14
67
115

answered Jul 12 '16 at 10:43

SouravA

5,147
2
24
49

Filter Set by another Set

1 Answers1