ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 9 question 2 discussion

Actual exam question from Microsoft's PL-300
Question #: 2
Topic #: 9
[All PL-300 Questions]

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:

Show Suggested Answer Hide Answer
Suggested Answer:
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.
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>[, <filter1> [, <filter2> [, ג€¦]]])
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(<table>,<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
by fred92 at Oct. 25, 2022, 8:29 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
fred92
Highly Voted 10 months ago
Answer is correct. CALCULATE FILTER Orders[ShippedDate] > Orders[RequiredDate]
upvoted 35 times
...
Wadyba
Highly Voted 9 months, 1 week ago
Correct Answer
upvoted 11 times
...
Shalaleh
Most Recent 3 months, 2 weeks ago
Given answer is correct.
upvoted 6 times
...
Hoeishetmogelijk
8 months, 2 weeks ago
Answer is correct.
upvoted 5 times
...
lukelin08
8 months, 3 weeks ago
Answer is correct. CALCULATE FILTER Orders[ShippedDate] > Orders[RequiredDate]
upvoted 7 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago