We have a cube with the following dimensions and measures:
Dimension called: Card Number
Dimension called: Transaction Type
With Levels: Load, Redeem, Unknown
Measure Called: Transaction Count
Is there a way to write a calculated measure to return the following?
The Distinct count of cards that have between 2 and 4 "load" transactions
and at least 1 "redeem" transaction

Note: We are using Analysis Services 2000, but are planning to move AS2005
soon

Thanks

Assuming that each leaf member of the Card Number dimension represents a
distinct card, and that what you meant by "With Levels: Load, Redeem,
Unknown" was actually members, not levels of the Transaction Type
dimension:

Count(Filter([Card Number].[Card Number].Members,
([Measures].[Transaction Count],
[Transaction Type].[Load]) >= 2 And
([Measures].[Transaction Count],
[Transaction Type].[Load]) <= 4 And
([Measures].[Transaction Count],
[Transaction Type].[Redeem]) >= 1))


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***