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

There's more…
DAX supports a lot of the same essential constructs of the T-SQL language such as
the ability to filter and order results. A basic element of a DAX query is that the re-
lationship between tables has already been established in the model and therefore
there is no need to join tables in the query as you would in SQL. This isn't to suggest
that we can't use more complex techniques to join non-related tables or combine
data in unique ways. DAX affords a lot of advanced functionality when it's needed.
If we change the SUMMARIZE function to begin with the Internet Sales table,
we can add table and column references for any table that is related either directly
or indirectly. Ordering the results is similar to SQL using the ORDER BY clause fol-
lowed by a series of table and column references. Let us execute the following step
to query the Model:
1. Write a new query using the following text and then execute it:
EVALUATE SUMMARIZE('Internet Sales',
Customer[FirstName]
, Customer[LastName], 'Product
Category'[CategoryName]
, "Sales Amt", 'Internet Sales'[Sales
Amount])