Time Intelligence function 4x times slower than Filter

[notem]

Simple model:

Query with FILTER:

Server Timings:

Query with Time Intelligence function:

Server Timings:

Can anybody explain this behaviour and give the links to articles with explanation?

[amitchandak]

@notem , One of the reasons which I can think of is that time intelligence will return all dates and create an in clause for that.

The best way to check is to enable performance analyzer and then get the DAX query from there and check

[notem]

@amitchandak, dax query from Performance Analyzer:

Let see on images from DaxStudio in my first message. There above 300 pseudo-sql queries for Time Intelligence like following:

... ORDER_ITEM LEFT OUT JOIN DATES ... WHERE DATES[ISO_DATE] IN ...

I think that situation occurs because of generality of the Time Intelligence functions. So Formula Engine can't  parse a query for good execution plan.
But I never seen info that Time Intelligence might be slower than filter.