This is not the post I planned to write.

I've got this theory. It's based on incomplete understanding, so. I strove forth to complete the understanding and totally failed. It's basically that. =CALCULATE([Calc], MyTable[Col1] = 5, MyTable[Col2] > 10) should be faster than =CALCULATE([Calc], FILTER(MyTable, MyTable[Col1] = 5 && MyTable[Col2] > 10))