I came across a video last week from Curbal that presented a discussion on the use of CALCULATETABLE in lieu of FILTER in many DAX expressions.
The video has a noticeable number of views and comments so is of interest to the community.
In that video, there was also a discussion of a Microsoft document that espoused avoiding the use of FILTER as a filter argument.
I don’t have an opinion on this myself, but, seeing as this is the first time I’ve come across this in the last 2 years and have personally experienced and created many successful Power BI reports that use FILTER as a filter argument in DAX measures, imagine this may only become an optimization issue when dealing with quite large datasets.
I’m creating this post as a starter for a discussion and encourage the forum at large to share their thoughts, especially those experienced in DAX optimization.