Query has exceeded the available resources.

Question

I'm having this error at my table after using multiple SUMX in a dax. Is there any alternate solution besides simplifying the query, reducing data volume, and optimizing the data model? hoping to fix it in an alternate Dax solution&nbsp;Cal_L2_amount_sumx =VAR cal = &nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; dim_cost_type,&nbsp; &nbsp; &nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dim_cost_center,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dim_cost_center[Level1] IN VALUES(dim_market[Market])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dim_brand,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; vc_dim_wrap,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dim_date,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [sum_amount]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )RETURN&nbsp; &nbsp; cal&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

bhanu_gautam · Answer

mann0321&nbsp;Try using&nbsp; SUMMARIZE to pre-aggregate the data at different levels before performing the final aggregation
&nbsp;
Cal_L2_amount_sumx =VAR summarizedTable =SUMMARIZE(dim_cost_center,dim_cost_center[Level1],dim_market[Market],dim_cost_type[CostType],dim_brand[Brand],vc_dim_wrap[Wrap],dim_date[Date],"SumAmount", SUM([sum_amount]))VAR filteredTable =FILTER(summarizedTable,dim_cost_center[Level1] IN VALUES(dim_market[Market]))RETURNSUMX(filteredTable, [SumAmount])

danextian · Answer

This measure is computationally expensive, primarily due to its heavy reliance on multiple nested SUMX functions and iterative calculations over potentially large tables.

Forum Discussion

Query has exceeded the available resources.

2 Replies

Related content

Query Exceeded Available Resource

visual has exceeded available resources

Query has exceeded available resources

query has exceeded to available resources

Visual has exceeded available resources