Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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...
Need Help
Tutorial Requests
  • mattbrice's avatar
    mattbrice
    9 years ago
    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's avatar
mattbrice
Solution Sage
9 years ago

There 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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

What if I remove CALCULATETABLE from the language.  What do we lose?

  • mattbrice's avatar
    mattbrice
    Solution Sage
    9 years ago
    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...