Applying a filter to remove an Individual Member from a measure

Hi eazyBI,

I am building out an average risk rating report for our projects. I am looking calculate two separate risk ratings, the first is with all request types(dimension and property) included and the second is with one of the request types excluded from the calculation.

I have built out the fist rating successfully:
([Risk].[Low]*1
+
[Risk].[Moderate]*2
+
[Risk].[High]*3
+
[Risk].[Critical]*4)/[Status].[In Queue & In Progress]

My question is how do I duplicate this into a new measure and apply a filter to exclude the one request type from the calculation?

Thanks.

To add to this I have managed to create a new calculated member for the exclusion, I need some guidance on applying that to a calculated measure.

Aggregate(
except([Request Type].Members,
{
[Request Type].[Termination]
})
)

Seems the final step here was to just use the SUM function in the calculated member and it’s now working.
SUM([Request Type].[No Termination],
([Risk].[Low]*1
+
[Risk].[Moderate]*2
+
[Risk].[High]*3
+
[Risk].[Critical]*4)/[Status].[In Queue & In Progress]
)