ssas - Calculated Member as an existing measure filtered by both a tuple and a set -

i'm looking create calculated member sql server data tools analysis services on olap cube combines following filtering approaches:

tuple

(     [enrolment planning actuals].[year].&[1],     [enrolment planning actuals].[attribute 1].&[y],     [enrolment planning actuals].[attribute 2].&[n],     [enrolment planning actuals].[attribute 3].&[n],     [measures].[count] ) 

set single member

sum(         except(         [enrolment planning actuals].[year].[year],         {             [enrolment planning actuals].[year].&[1]         }     ),     [measures].[count] )    

the [enrolment planning actuals].[year] has members of values 1, 2, 3, 4 , want calculated member provide [measures].[count] filtered on:

• include [enrolment planning actuals].[year] members except [enrolment planning actuals].[year].&[1]
• [enrolment planning actuals].[attribute 1].&[y]
• [enrolment planning actuals].[attribute 2].&[n]
• [enrolment planning actuals].[attribute 3].&[n]

i recognize sum function may wrong approach in attempting combine these filters.

i found accepted answer article mdx calculated member filter dimension attribute exceptionally helpful point.

perhaps fundamentally there wrong in way of thinking. open suggestion, thank you.

you there buddy.

just extending on concept of set , tuple, , adding on concept of crossjoin or *, here should work:

with member measures.yourcalculatedmember  sum(     except(             [enrolment planning actuals].[year].[year],             {                 [enrolment planning actuals].[year].&[1]             }           ) *     [enrolment planning actuals].[attribute 1].&[y] *     [enrolment planning actuals].[attribute 2].&[n] *     [enrolment planning actuals].[attribute 3].&[n]     ,     [measures].[count]   )