Question 390
An analyst is troubleshooting this business scenario: A company needs a non-additive distinct count of active customers by month, not a sum of monthly counts. The attempt does not achieve the expected result. Which specific failure best explains the gap?
Explanation
Correct Answer
This defect explains why the required behavior failed. Distinct counts across periods are not generally additive. The corrective action is: Compute DISTINCTCOUNT of customer IDs in the selected period under the appropriate active-customer filter.
Incorrect Answers
Changing the column name to 'Link' without its category does not guarantee hyperlink behavior. The stated evidence instead indicates: Summing each month's distinct customer count double-counts repeat buyers.
A static calculated table of total profit does not automatically honor arbitrary report filters. The stated evidence instead indicates: Summing each month's distinct customer count double-counts repeat buyers.
Keeping long repeating product strings on every fact record wastes compression and complicates maintenance. The stated evidence instead indicates: Summing each month's distinct customer count double-counts repeat buyers.