Exam PL-300 topic 13 question 2 discussion

According to other websites the correct options are A. a measure that uses a formula of SUM (sales[sales_id]) B. a calculated column that use a formula of COUNTA(sales [sales_id]) C. a measure that uses a formula of COUNTROWS (Sales) D. a calculated column that use a formula of SUM (sales [sales_id]) The sale department require reports that contain the number of sales transactions. Correct answer is C

None seem to be correct as sales department requires the number of transactions

A: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])

The SUMX is an iterator function which Only counts the numbers in the column. Blanks, logical values, and text are ignored. https://learn.microsoft.com/en-us/dax/sumx-function-dax Correct answer is A

Correct answer is: A: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])

I think this is the important information: You are concerned with the quality and completeness of the sales data. You must ensure that negative and missing sales_amount values do NOT contribute to the total sales amount calculation. Since the sales managers require a visual to analyze sales performance, we will need a measure based on sales_amount that ignores the potentially incorrect values - negative and blank values. I would choose A.

Options are wrong, we should use Countrows function.

dejavu

This is a duplicate of question 4 of topic 8 but with the selection of answers from question 5 topic 8. I would suggest to ignore this one

I think the angle this question is coming from is from this sentence..."You must ensure that negative and missing sales_amount values do NOT contribute to the total sales amount calculation."

this exact question appear in my exam 10/29/2022