How should you complete the DAX expression?

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.

View Answer

Answer:

Explanation:

Box 1: CALCULATE

CALCULATE evaluates an expression in a modified filter context.

Syntax: CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])

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>,<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