Add to Chrome
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
What does this DAX expression return?COUNTROWS(FILTER(Sales, Sales[Amount] > 100))
COUNTROWS(FILTER(Sales, Sales[Amount] > 100))
The sum of all amounts greater than 100, although it sounds technically credible, it does not align with how DAX functions propagate context in this scenario.
A calculation pattern that is useful for measures in general but does not satisfy the specific context transition requirement here
A filtered table, however, this wording confuses row context, filter context, or evaluation timing and therefore misses the exact DAX behavior being tested.
An error because FILTER cannot be used with COUNTROWS, although it sounds technically credible, it does not align with how DAX functions propagate context in this scenario.
The count of rows in Sales where Amount is greater than 100
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!