Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have created a composite model with aggregations of my sales tables. When querying sales (SUM() of a column) by year in a table, as expected a DAX query is ran against the aggregated table. If in my DAX formula I calculate sales for a chosen year, if I do not use a filter argument
then a DAX query is running as expected against the aggregated table.
When I use a filter argument on the calendar table to calculate it in the same way, this then runs a Direct Query when it is not needed.
I understand the filter argument is not needed in this situation, but more complex situations make it unavoidable. The calendar table is set to dual storage mode, so is capable of not running the Direct Query.
Is there any advice around this or reasoning as to why this is happening?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.