Multiple SUMX makes my table slow

[chaichatp]

I try to do Weighted score by multiplying SCORES of each category with Parameter then plus everything and becomes like this. Any suggestions?

SCORE Simulated =

SUMX('EQTY-SCORE',[SCORE Total] * [EQTY-Prmtr-SCORE Value])+

SUMX('EQTY-SCORE',[Rank DefaultRisk] * [EQTY-Prmtr-IG Value])+

SUMX('EQTY-SCORE',[Rank4Allctn DDM IRR] * [EQTY-Prmtr-IRR Value])+

SUMX('EQTY-SCORE',[Rank4Allctn BBG LTG] * [EQTY-Prmtr-LTG Value])+

SUMX('EQTY-Correl_EPS_10Yrs',[Rank4Allctn Crrl EPS3Yrs] * [EQTY-Prmtr-EPS3Yrs Value])+

SUMX('EQTY-Correl_EPS_10Yrs',[Rank4Allctn Crrl EPS5Yrs] * [EQTY-Prmtr-EPS5Yrs Value])+

SUMX('EQTY-Correl_EPS_10Yrs',[Rank4Allctn Crrl Price3Yrs] * [EQTY-Prmtr-Price3Yrs Value])+

SUMX('EQTY-Correl_EPS_10Yrs',[Rank4Allctn Crrl Price5Yrs] * [EQTY-Prmtr-Price5Yrs Value])

[amitchandak]

@chaichatp , Try if this works better

SCORE Simulated =
SUMX('EQTY-SCORE',([SCORE Total] * [EQTY-Prmtr-SCORE Value])+ ([Rank DefaultRisk] * [EQTY-Prmtr-IG Value])+ ([Rank4Allctn DDM IRR] * [EQTY-Prmtr-IRR Value])+
([Rank4Allctn BBG LTG] * [EQTY-Prmtr-LTG Value]))+
SUMX('EQTY-Correl_EPS_10Yrs',([Rank4Allctn Crrl EPS3Yrs] * [EQTY-Prmtr-EPS3Yrs Value])+
([Rank4Allctn Crrl EPS5Yrs] * [EQTY-Prmtr-EPS5Yrs Value])+
('EQTY-Correl_EPS_10Yrs',[Rank4Allctn Crrl Price3Yrs] * [EQTY-Prmtr-Price3Yrs Value])+
('EQTY-Correl_EPS_10Yrs',[Rank4Allctn Crrl Price5Yrs] * [EQTY-Prmtr-Price5Yrs Value]))

[chaichatp]

I got this error for both ways

[amitchandak · Accepted solution]

@chaichatp , My mistake table name left

SCORE Simulated =
SUMX('EQTY-SCORE',([SCORE Total] * [EQTY-Prmtr-SCORE Value])+ ([Rank DefaultRisk] * [EQTY-Prmtr-IG Value])+ ([Rank4Allctn DDM IRR] * [EQTY-Prmtr-IRR Value])+
([Rank4Allctn BBG LTG] * [EQTY-Prmtr-LTG Value]))+
SUMX('EQTY-Correl_EPS_10Yrs',([Rank4Allctn Crrl EPS3Yrs] * [EQTY-Prmtr-EPS3Yrs Value])+
([Rank4Allctn Crrl EPS5Yrs] * [EQTY-Prmtr-EPS5Yrs Value])+
([Rank4Allctn Crrl Price3Yrs] * [EQTY-Prmtr-Price3Yrs Value])+
([Rank4Allctn Crrl Price5Yrs] * [EQTY-Prmtr-Price5Yrs Value]))

[chaichatp]

Thank you but that didnt help it load faster. I might need to find out more what makes it slow. At least i know how to construct the SUMX formula correctly.