Forum Discussion

DataSciWannabe's avatar
DataSciWannabe
Frequent Visitor
7 years ago

Slow SumX - How to Make Faster

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) ))

Need Help

4 Replies

  • DataSciWannabe's avatar
    DataSciWannabe
    Frequent Visitor
    7 years ago

    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

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    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

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    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