I am trying to put two different restrictions in the where clause from two different dimensions. The Microsoft documentation shows examples of this, but I'm getting the error: Cannot convert set to tuple in the {...} function. Can somebody help? Using foodmart, I want to show the top 3 customers that are college educated and not married. My attempt is below. If I leave out the College Educated or Marital Status part of the WHERE clause, it will work

WITH member [Education Level].[College Educated] as 'sum({[Education Level].[Bachelors Degree], [Education Level].[Graduate Degree]})'
SELECT {[Measures].[Unit Sales]
on columns, TOPCOUNT({[Customers].[Name].members},3,[Measures].[Unit Sales]
on rows FROM Sales WHERE {[Marital Status].[S],[Education Level].[College Educated]}

WITH member
[Education Level].[College Educated] as 'sum({[Education
Level].[Bachelors Degree], [Education Level].[Graduate Degree]})'

SELECT {[Measures].[Unit Sales]} on columns,
TOPCOUNT({[Customers].[Name].members},3,[Measures].[Unit
Sales]) on rows
FROM Sales WHERE ([Marital Status].[S], [Education Level].[College
Educated])

good luck

Sascha

"Andrea Worley" <k_rage (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:77BDC0C8-184E-47B6-9E2C-9B32D156DE32 (AT) microsoft (DOT) com...
but I'm getting the error: Cannot convert set to tuple in the {...}
function. Can somebody help? Using foodmart, I want to show the top 3
customers that are college educated and not married. My attempt is below.
If I leave out the College Educated or Marital Status part of the WHERE
clause, it will work.

I thought I tried every combination of {} and (). Thanks so much. I'm still learning the difference of all the subtle (to me) notations.