Forum Discussion
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(FIL...
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