DAX Calculations and Queries - SQL Server Analysis Services 2012 Cube Development - page 394

ORDER BY Customer[LastName],
Customer[FirstName]
, 'Product Category'[CategoryName]
The results are shown in the following screenshot, which shows us the total
of sales for each product category purchased by each customer:
2. To filter results you can use, you guessed it, the FILTER function, which
wraps a table expression and operates on the columns and values it con-
tains. You can do it by entering the query, selecting the text, and executing it
as follows:
EVALUATE
FILTER(
SUMMARIZE('Internet Sales',
'Date'[CalendarYear]
, Customer[FirstName],
Customer[LastName]
, 'Product Category'[CategoryName]
, "Sales Amt", 'Internet
Sales'[Sales Amount])
, 'Date'[CalendarYear] = 2008)