Рет қаралды 1,488
A strange behaviour happens when we use Calculate with and without FILTER and we explain here the reason with a clear example.
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.
Therefore, FILTER retains and interacts with initial filter context (in our case the pivot table), while filter expression used directly in CALCULATE ignores it.
#dax #powerbi #calculate #filter