Slow SumX - How to Make Faster

[DataSciWannabe]

I am using nested sumx to get the results of a count of a seperate measure, I was wondering if anyone had any ideas of how to speed it up? I had to use this to get the numbers to tie out.

sumx(values(Data[Name]),sumx(values('Data'[Item number]), if(AND([Price_Chg] > 0.02,[Price_Chg] < 0.03),1,0) ))

[v-piga-msft]

Hi @DataSciWannabe ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)

Best Regards,

Cherry

[v-piga-msft]

Hi @DataSciWannabe ,

It seems that you use two SUMX functions, so the performance should be bad.

I'm afraid that you could try calculated table.

In addition, you could refer to this similar thread.

If you still need help, please share your data sample so that I could have a test on it.

Best  Regards,

Cherry

[DataSciWannabe]

Also note the idea is to sum the total number of rows where the result of the measure which calculates price change falls within those ranges

[DataSciWannabe]

anyone?