Forum Discussion
Query has exceeded the available resources.
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...
This measure is computationally expensive, primarily due to its heavy reliance on multiple nested SUMX functions and iterative calculations over potentially large tables.