Direct Query with Calculation Groups

[mhumpher]

I have a composite model that I'm adding calculation group to. It includes a fact table of sales which includes an application submission date and a paid date. Alongside this I have a date table which are related. I've added a calculation group that can switch between using the submission date and the paid date to calculate measures. I also have a date aggregation calculation group that looks at dates weekly, monthly and on a rolling 4 week. 

If I do not filter the data by anything else, I can use both calculation groups and I get a full set of data. When I add a filter, for example on product in another dimension table, suddenly the visual only gives me a partial set of data. If I remove the date aggregations calculation group and keep the filter, I get a full set of data again. 

When I compare the queries generated from the Performance Analyzer, the main difference is that the DirectQuery section with the date aggregation creates a variable with a seemingly arbitrary list of date from the date table.

How can I prevent or work around this behavior?

[amitchandak · Accepted solution]

@mhumpher , date aggregations mean grouping data by date, try not to use date hierarchy. 

if date aggregations mean implicit measure sum of date, without measure, that will not work well with calculation group