Exam PL-300 topic 8 question 5 discussion

legit answer 🤙🤙🤙

B is the only option that ignores blanks and negative values

We need to discard missing and negative sales_amount from the total sales_amount calculation. Summing all the sales_amount would, by default, not consider missing amounts as there would be nothing there so we only needs to take car of the negative amounts. Using ABS function as in option A, we would turn negative amounts into positive amounts but we wouldn't get rid of them and would be included in the total calculation In option C we are summing everything including the negative values should not be considered. Option C is just discarding the missing amounts (assuming they to be BLANK not '0', which is not clear defined in the statement of the question) but is not discarding the negative amounts. In Option B, we are using an IF function to consider only positive values in the total calculation

Can't believe it, even Answer D has the extra parenthesis. Now which is which???

ABS return Absolute number. and we need a measure not a calculated column

The error in the formula for B it's probably just a typo. D option would work on the missing values, but not with the negative values

I think the extra parenthesis is just a typo. D would make blank sales value equal to 0 which would be included in the analysis which we don't want.

Answer is B

Answer B has wrong syntax.

B only if it had the correct parentheses as per this formula - tested. SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0),[sales_amount])

I'd go for D, the formula in B is not correct, due to the brackets.

B has 2 opening brackets '(', but 3 closing bracket ')'. A bit strange