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:Suggested Answer:
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. Incorrect: * COUNTX - Counts the number of rows that contain a non-blank value or an expression that evaluates to a non-blank value, when evaluating an expression over a table. * CALCULATETABLE evaluates a table expression in a modified filter context. Syntax: CALCULATETABLE( [, [, [, ג€¦]]]) Expression - The table expression to be evaluated. Box 2: FILTER - FILTER returns a table that represents a subset of another table or expression. Syntax: FILTER( ,
) 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 This question is in PL-300 Microsoft Power BI Data Analyst Exam For getting Microsoft Certified: Power BI Data Analyst Associate Certificate Disclaimers: The website is not related to, affiliated with, endorsed or authorized by Microsoft. The website does not contain actual questions and answers from Microsoft's Certification Exams. Trademarks, certification & product names are used for reference only and belong to Microsoft. Please login or Register to submit your answer
