Aggregation/Composite Model issue with DAX calculated table

Question

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 · Answer

Hi&nbsp;rustice&nbsp;,
I have a little confused about your scenario.
What is mean of "&nbsp;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
&nbsp;

rustice · Answer

Hi Cherry, this is what I meant by "Dual":https://radacad.com/dual-storage-mode-the-most-important-configuration-for-aggregations-step-2-power-bi-aggregations

Forum Discussion

Aggregation/Composite Model issue with DAX calculated table

2 Replies

Related content

Direct Lake Model - Calculated Column/Tables

Directlake semantic model, calculated table

Measure/Model calculation support needed

Help with Aggregations and Composite models.

Modelling