Given this measure:

Red Product Sales = CALCULATE([Total Sales], Products[Color] = "Red")

If a user filters the report to show only Blue products, what will this measure display?

Question

Given this measure: 
 
 Red Product Sales = CALCULATE([Total Sales], Products[Color] = "Red") 
 
 If a user filters the report to show only Blue products, what will this measure display?

Answer

A calculation pattern that is useful for measures in general but does not satisfy the specific context transition requirement here

Answer

Sales of both Red and Blue products, however, this wording confuses row context, filter context, or evaluation timing and therefore misses the exact DAX behavior being tested.

Answer

An error, although it sounds technically credible, it does not align with how DAX functions propagate context in this scenario.

Answer

Sales of Red products only (the CALCULATE filter overrides the visual filter for Color)

Answer

Zero, because the visual is filtered to Blue, although it sounds technically credible, it does not align with how DAX functions propagate context in this scenario.

Crowdly

Given this measure: Red Product Sales = CALCULATE([Total Sales], Products...

Хочете миттєвий доступ до всіх перевірених відповідей на learning.devinci.fr?