October MDX Puzzle Solution Revealed

From the FoodMart (or FoodMart 2000) Sales cube, list the beer products that have at least 100 unique customers. For each of these popular beers, display the unit sales and the number of customers.

WITH member [Measures].[NumCust] AS 'Count( Filter(
	[Customers].[Name].Members, Not IsEmpty([Unit Sales]) ) )'
	SET [Popular Beers] AS 'Filter([Beer].Children, [NumCust] > 100)'
SELECT [Popular Beers] ON columns,
	{ [Unit Sales], [NumCust] } ON rows
FROM Sales

To solve this puzzle, I created a calculated member that returns the number of unique customers for a particular product. Then, I created a set that included the beer products that had more than 100 unique customers.