Question 40
A model/report has an issue while addressing this requirement: A modeler needs a reusable measure for the count of nonblank CustomerEmail entries, excluding missing values. Which mistake would account for the observed failure?
Explanation
Correct Answer
This defect explains why the required behavior failed. COUNTA counts nonblank values irrespective of text or numeric type. The corrective action is: Use `COUNT(Customer[CustomerEmail])` only for numeric columns; for emails use `COUNTA(Customer[CustomerEmail])` or a defined nonblank filter.
Incorrect Answers
A rolling 12-month total is not the same period as calendar year-to-date. The stated evidence instead indicates: COUNT on a text email column is not the appropriate general nonblank-text aggregation.
Placing Store above Region reverses the logical parent-to-child navigation. The stated evidence instead indicates: COUNT on a text email column is not the appropriate general nonblank-text aggregation.
Using only existing transaction dates can omit days and break expected date calculations. The stated evidence instead indicates: COUNT on a text email column is not the appropriate general nonblank-text aggregation.