Add to Chrome
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
To calculate each product's percentage of total sales (ignoring product filters), which measure is correct?
DIVIDE([Total Sales], [Total Sales]), although it sounds technically credible, it does not align with how DAX functions propagate context in this scenario.
CALCULATE([Total Sales] / ALL(Products)), although it sounds technically credible, it does not align with how DAX functions propagate context in this scenario.
[Total Sales] / SUM(Sales[Amount]), however, this wording confuses row context, filter context, or evaluation timing and therefore misses the exact DAX behavior being tested.
A syntax-level statement that appears valid but actually describes iterator usage in a context where scalar evaluation is required
DIVIDE([Total Sales], CALCULATE([Total Sales], ALL(Products)))
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!