Aggregation/Composite Model issue with DAX calculated table

[rustice]

I have a very simple model with a Fact Table (DirectQuery), the Agg table (Import) and then the DateDim being a calculated table. The aggregation works until the moment I drag and drop the date from my DateDim. At that point it is still sending queries back to my SQL db. Since I can't convert a DAX table to Dual, is there a limitation when using DAX calculated tables (which by default are import/cached) or am I missing something?

[v-piga-msft]

Hi @rustice ,

I have a little confused about your scenario.

What is mean of " Dual "?

Actually, if you use direct query mode, there should be some limitations for dax. You could have a good look at this document and this blog.

Best Regards,

Cherry

[rustice]

Hi Cherry, this is what I meant by "Dual":

https://radacad.com/dual-storage-mode-the-most-important-configuration-for-aggregations-step-2-power...