Different results using CALCULATE with or without FILTER function
Revenue Red =
CALCULATE(
[Revenue],
FILTER(
'Product',
'Product'[Color] = "Red"
)
)
This should return the same result as
Revenue Red = CALCULATE([Revenue], 'Product'[Color] = "Red")
as explained the Modify DAX filter context in Power BI Desktop models course unit 2
but the visual result is different
This is the result with the formula with FILTER
While this is the result without FILTER, using normal sintax of the CALCULATE function
You can see that the value of revenue red is written in each row, but this behaviour is not mentioned in the course. Instead it is mentioned that every CALCULATE function uses in background a FILTER function but that, for ease of use and understandability of the syntax, the FILTER is omitted. This should imply that the final result is the same, aside from the formula writing type, but it seems not to be so.
This question is related to the following Learning Module