Prolly easy question, but for some reason the query below does not return the distinct count but just the count. Should be 16 but it's retruning 17. Any help?
WITH SET [MySet] AS
instr(left([Geography].[City].currentmember.name,1), 'A') > 0
[Measures].[Internet Order Count]
MEMBER [Measures].[CountMembers] AS
//why not distinct?
[Measures].[Internet Order Count],
FROM [Adventure Works]