Forum Discussion
ed_mcdill
Advocate II
Advocate IINested 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
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi 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