HOTSPOT
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.
Hot Area:
Explanation/Reference: 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(
,) 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. Reference: https://docs.microsoft.com/en-us/dax/calculate-function-dax https://docs.microsoft.com/en-us/dax/filter-function-dax