DRAG DROP
You are a business analyst for a company that uses a Microsoft SQL Server Analysis Services (SSAS) tabular database for reporting. The database model contains the following tables:
You have been asked to write a query for a report that returns the total sales for each product subcategory, as well as for each product category.
You need to write the query to return the data for the report.
How should you complete the DAX statement? To answer, drag the appropriate DAX segment to the correct locations. Each DAX segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:
example, consider the following query. producing this result.
Answer: 
Explanation:
Note: The behavior of SUMMARIZE is similar to the GROUP BY syntax of a SELECT statement in SQL. For
EVALUATE
SUMMARIZE(
‘Internet Sales’,
‘Internet Sales'[Order Date],
“Sales Amount”, SUM( ‘Internet Sales'[Sales Amount] )
)
This query calculates the total of Sales Amount for each date in which there is at least one order,
Reference: https://msdn.microsoft.com/en-us/library/gg492171.aspx