Forum Discussion

jzhao's avatar
jzhao
Frequent Visitor
2 years ago

is function filter and the filter expression in calculate function the same?

I want to sum up sales with same store ID, are the following calculated columns interchangeable? They did give me the same result so far.
Method 1:
Sales =
var curid ='table1'[ID]
return SUMX(FILTER('table2',curid='table2'[ID]),'table2'[Sales__Local_currency])
 
Method2:
Sales 2 = CALCULATE(SUMX('table2','table2'[Sales__Local_currency]), 'table1'[ID]=RELATED('table2'[ID]))

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    The main difference between the FILTER() function and the filter expression in the CALCULATE() function is that the FILTER() function returns a new table, while the filter expression in the CALCULATE() function modifies the filter context of the current calculation. I think method 2 is better