The short answer is yes. However, MDX is not the most user friendly language so it us not intuitively obvious.

Have a look at the syntax used in the following statements. The first filters on 1997.Q1 by placing it in the WHERE clause. The second gets the same result but by specifying the "filter" as part of the "WITH MEMBER". The third extends this so that a range of quarters is used. The values returned by the third query are a bit weird - I don't have time at present to analyse why that is happening.

Using the syntax similar to the third example, you can also specify a list of members if you so desire.

with
member [Product].[All Products].[Drink].[Percent of Alcoholic Drinks] as '[Product].[All Products].[Drink].[Alcoholic Beverages]/[Product].[All Products].[Drink]', format = '#.00%'
select
{ [Product].[All Products].[Drink].[Percent of Alcoholic Drinks] } on columns,
order([Customers].[All Customers].[USA].[WA].Children, [Product].[All Products].[Drink].[Percent of Alcoholic Drinks],BDESC ) on rows
from Sales
where ( [Measures].[Unit Sales],[Time].[1997].[Q1] )




with
member [Product].[All Products].[Drink].[Percent of Alcoholic Drinks] as 'sum ( {[Time].[1997].[Q1] } , [Product].[All Products].[Drink].[Alcoholic Beverages] / [Product].[All Products].[Drink] ) ', format = '#.00%'
select
{ [Product].[All Products].[Drink].[Percent of Alcoholic Drinks] } on columns,
order([Customers].[All Customers].[USA].[WA].Children, [Product].[All Products].[Drink].[Percent of Alcoholic Drinks],BDESC ) on rows
from Sales
where ( [Measures].[Unit Sales] )

with
member [Product].[All Products].[Drink].[Percent of Alcoholic Drinks] as 'sum ( {[Time].[1997].[Q1] : [Time].[1997].[Q4] } , [Product].[All Products].[Drink].[Alcoholic Beverages] / [Product].[All Products].[Drink] ) ', format = '#.00%'
select
{ [Product].[All Products].[Drink].[Percent of Alcoholic Drinks] } on columns,
order([Customers].[All Customers].[USA].[WA].Children, [Product].[All Products].[Drink].[Percent of Alcoholic Drinks],BDESC ) on rows
from Sales
where ( [Measures].[Unit Sales] )