Forum Discussion

FelipeDBA's avatar
FelipeDBA
Frequent Visitor
6 years ago
Solved

Slow cumulative sum - ABC analysis

Hi, I'm struggling  with a kind of abc analysis. I have a dimesion with around 200 thousand customer and a fact table with around 20M rows. What I need is count the number of customers that represent...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    FelipeDBA performance of the measure is dependent on many factors, like your data model, the relationship of the tables etc. It is not easy and straight forward answers, I have worked with tables over 100m rows and with DAX studio, I was able to tweak the measures to perform faster, in nutshell, it is not easy without looking at all the details, model and relationship and what you are trying to do. I know it is not a solution to your question, but there is no other shortcut.

parry2k's avatar
parry2k
Super User
6 years ago

FelipeDBA performance of the measure is dependent on many factors, like your data model, the relationship of the tables etc. It is not easy and straight forward answers, I have worked with tables over 100m rows and with DAX studio, I was able to tweak the measures to perform faster, in nutshell, it is not easy without looking at all the details, model and relationship and what you are trying to do. I know it is not a solution to your question, but there is no other shortcut.