POWER BI SUMX + measure slow

[Peter_Sun]

Hi All, 

I manage to calculate below two measures. and the 2nd step is built on the measure from 1st Step. 

1st Step:

DP = CALCULATE( DISTINCTCOUNT( FACT_Sales[Item Name]), ALLEXCEPT(FACT_Sales, FACT_Sales[Customer Name]), FILTER( FACT_Sales, FACT_Sales[Item Order Amt CNY] >0))

2nd Sep:

DPs Total = SUMX( VALUES(FACT_Sales[Customer Name]), 'Key Measures-DPs'[DP])

However, the report became extremely slow to refresh based on my  slicers like Date or Channels after the second DAX-DPs Total.

Would you please check if I can optimise this DAX formula to improve the performance?

Thanks You all

[GilbertQ]

Hi @Peter_Sun

With your second measure what are you trying to get the result of for your measure?

Is it a total of all Customers?

[Peter_Sun]

Hi, 

The measure I am trying to get is tell me how many listings I have in my business scenarios. 

One listing means a product sold to one customer. 

For example, 

If one product sold to two customers, we have two listings or 

If two products sold to one customer, we have two listings as well. 

Or do you have any other better measures to calculate this out?

really thanks for your help. 

[v-chuncz-msft]

@Peter_Sun,

You may also try calculated table.