Aggregation tables cannot be on the filtering side of relationships to the other tables that are not

[koushikchandra]

I have a sales detail table (Direct Query) and sales agg table (Impot Mode) in the backend DB. Created a Date dimension and Month-Year Dimension in Power BI level (both are on Import Mode). Defined the relationship. Next step I am trying define agreegation on sales agg table but that is complaining "Aggregation tables cannot be on the filtering side of relationships to the other tables that are not agreegation tables"

The end goal is : whenever user will be fetching SAALES_AMT and YEAR, then it should fetch from in-memory, though "

TotalSales = SUM(SALES_DQ_COLD[SALES_AMT])". Ideally it should automatically re-direct to inmemory agg table.

[YunierG]

Hi, i have the same error, i see the report error was 2023, but now in PBI desktop april 2025, i have the same error when make the relationships.
i miss something configuration or issue in new versions?

[some_bih]

Hi @koushikchandra according to msg error is type of relationship table DIM_MONTH_YEAR  and SALES_IMP_HOT, changee it and try agg. Hope this help, kudos appreciated.