Let’s define two similar queries for 2004 and 2005. The query for 2004 looks like:

The queries are merged by Service:

Now we want to filter table based on a measure from one of the queries.

Let’s define variable v_Filter as

=Abs([2004].[Revenue])<100000

With the following report filter, the table will show 3 rows and it is expected.

But we will get not quite expected results when one of “non-merged” objects is used.

With [2004].[Service], the filter will remove only numbers that does not match restriction.

With [2005].[Service], the filter will be ignored.

Why? It seems it worked more predictable in earlier versions.