Hi, I'm trying to create a new calcluated member in visula studio
business intelligence studio.
For some reason this is proving to be very frustrating.

Please can someone try and explain why, the folling is happening and
what I can do about it....

creating a new calculated member based on [Measures].[Transaction
Count] which is itself aggregated as SUM.

This works:
CASE WHEN [Measures].[Transaction Count] > 1 THEN 1 ELSE 0 END

This also works:
SUM([Measures].[Transaction Count])

However this is NOT WORKING:
SUM(CASE WHEN [Measures].[Transaction Count] > 1 THEN 1 ELSE 0
END)

Im trying to get a measure for the number of records that had a
transaction count > 1 but unfortunately what seems like a simple
calculation is turning out to be a a real pain.

Note: I have also tried to turn off the aggregation function on the
parent measure [Transaction Count] but this doesnt make a difference.
It is still giving the #VALUE! error when I browse the cube.