OPTIMIZE SUMX FORMULA

[cdawidow]

Hi guys,  I have the following formula :  

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!

[Anonymous]

From your formula one does not know how things are calculated and what the model looks like. Without this information nobody can give you any better version of your measure.

[amitchandak]

@cdawidow , what you are doing is correct. Another way is bucketing/ binning. Little bit tricky. You need an independent table to

refer if a blog or video can help

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k