View all questions & answers for the PL-300 exam
You need to create a measure that will return the percentage of late orders.
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.
Box 1: CALCULATE
CALCULATE evaluates an expression in a modified filter context.
Syntax: CALCULATE([, [, [, …]]])
Expression - The expression to be evaluated.
filter1, filter2,… (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions.
Box 2: FILTER
FILTER returns a table that represents a subset of another table or expression.
Syntax: FILTER(<title>,)
Table- The table to be filtered. The table can also be an expression that results in a table.
Filter - A Boolean expression that is to be evaluated for each row of the table. For example, [Amount] > 0 or [Region] = "France"
Box 3: Orders[ShippedDate]> Orders[RequiredDate]
Northwind Traders defines late orders as those shipped after the required shipping date.
Submit