DAX Calculate function with and without FILTER

[Arnault_]

Hi,

Is there any difference between the two following measures? I get the same results in my report, but I am wondering why I should use FILTER then.

Thanks in advance.

Total shipment / sea = 
CALCULATE (
    [Total shipment];
    FILTER ( 'DIM Transport'; 'DIM Transport'[mode_transport_STD] = "SEA" )
)

Total shipment / sea v2 = 
CALCULATE ( [Total shipment]; 'DIM Transport'[mode_transport_STD] = "SEA" )

[Ashish_Mathur]

Hi,

There are 3 triggers for usage of the FILTER() function

1. When resolving a conflict - If the same field is placed in a slicer and in the filter argument of the CALCULATE() function, then if a FILTER() function is not used, precedence is given to the filter argument of the CALCULATE() function (completely ignoring the selection made by the end user in the slicer).  If the FILTER() function is used in the filter argument of the CALCULATE() function, then precedence is given to the selection made by the end user in the slicer.
2. When giving rich filter conditions - Simple filter conditions such as column value > fixed value do not warrant usage of FILTER() function.  Rich filter conditions such as column value > column value or column value > measure or measure > measure require usage of the FILTER() function.
3. When giving OR conditions - Even though one can specify unlimited filter conditions in the CALCULATE() function, they are all AND conditions by default.  To specify OR conditions, one must use the FILTER() function.  That being said, there is a way to bypass the FILTER() function by using the || symbol to specify OR conditions.

Hope this helps.

[Arnault_ · Accepted solution]

I guess this is answering my question : 

https://stackoverflow.com/questions/50506030/dax-calculate-function-with-and-without-filter