Forum Discussion
Solved
Nested Sumx performance
Project Management Cost_Variable_Target = VAR TargetPercentage = ADDCOLUMNS ( Projects, "Target_Percent", SWITCH ( TRUE (), Projects[Project_Type] = "Type A", 0.125, Projects[Project_Type] ...
Hi ed_mcdill,
Based on my research, the SUMX function might affect the execution performance, especially nested SUMX. You could refer to below blogs to optimizie your DAX formula:
Tune your PowerPivot DAX query, don’t use the entire table in a FILTER and replace SUMX if possible
Best regards,
Yuliana Gu
Review this article here:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
thanks for the link
