Forum Discussion
FILTER vs CALCULATETABLE
I'm about to lose some serious street cred, but so be it... :) I use FILTER( ) all the time and CALCULATETABLE( ) almost never. Is there some time I *should* be using CALCULATETABLE? What is th...
Anonymous wrote:What if I remove CALCULATETABLE from the language. What do we lose?
CALCULATETABLE triggers context transition whereas FILTER does not. Andy by itself, FILTER creates a row context whereas CALCULATETABLE does not. But other than these, it is a question for Marco if he is lurking around out there...potential performance issues per his article I referenced would be one thing I would think...
mattbrice
Solution Sage
Solution SageThere is row context because both look to be calculated columns,...not measures. And of course calculated columns have row context, but only transitioned to filter context with use of CALCULATE or CALCULATETABLE or some other table function.
What if I remove CALCULATETABLE from the language. What do we lose?