I have a dimension with two levels, and I want to return a set of the
top members, but filtered against a measure at the lower level.

So I want to check each SKU cost to see if it is greater than $100, and
if even a single SKU meets this criteria, the set includes that
category.

Example: Product Dimension: Categories Level --> SKU Level

FILTER([Product].[Categories].Members,
([Product].[SKU],[Measures].[Cost] > $100))
(This doesn't work)

Any help appreciated. Thanks

You can check if the count of such descendants is > 0:

Count(Filter(Descendants(
[Product].CurrentMember, [Product].[SKU]),
[Measures].[Cost] > $100)) > 0)

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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