TOP SALES = VAR X = FILTER(VALUES(CUSTOMERS[CNAME]), SCORE TOTAL>=30) RETURN SUMX(X,[CUSTOMER AVERAGE SPEND])
Essentially I have calculated a score based on multiple factors ( SCORE TOTAL) and broken them down in desired groups.
TOP : SCORE TOTAL >=30
STRONG: SCORE TOTAL >=20 <30
POOR : SCORE TOTAL <20
Is there any other methods out there apart from SUMX (which I am using) to ensure faster measure performance? Currently, the formula I am using is taking a long time to run. Any suggestions would be appreciated!