How should you complete the DAX expression?

HOTSPOT

Your company has affiliates who help the company acquire customers.

You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.

The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.

You need to develop a measure to support the visual.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

View Answer

Answer:

Explanation:

Box 1: CALCULATE

Start with CALCULATE and use a SUMX.

CALCULATE evaluates an expression in a modified filter context.

Box 2: SUM

Box 3: TOPN

TOPN returns the top N rows of the specified table.

Box 4: [TransactionDate]

TOPN Syntax: TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]…])

The orderBy_expression: Any DAX expression where the result value is used to sort the table and it is evaluated for each row of table.