Forum Discussion
Query Resources Exceeded Error ABC classification
Hi Community,
I’m building an Item Weightage Analysis table in Power BI.
I want to add a new measure which is:
Accumulated Share % (12M) → cumulative sum of “Share % Sales Value per Item (12M)” in descending order of sales within each Cat1.
Example for FE CYLINDER:
36.24% → 36.24%
8.33% → 44.57%
7.02% → 51.59%
… and so on.
I tried measure using RANKX + TOPN + SUMX. It works, but on 100k+ items I get “Query has exceeded available resources”. Next, I intended to calculate a new measure which returns A for those items having cumulative % less than 80%, B for which between 80% to 95% and C for which between 95% to 100%.
What’s the best practice to calculate this cumulative % by category at scale?Any guidance, optimized DAX, or advice on whether to pre-aggregate this in the data source would be really helpful🙏
SQLBI have a pattern for ABC analysis which you can read about at https://www.daxpatterns.com/abc-classification/ .
They also have a library of functions, using the new user defined functions in public preview in the September 2025 update, which you can find at https://daxlib.org/package/DaxPatterns.AbcClassification/ .
5 Replies
Maybe its exceeding 225 seonds limitation set by PBI desktop.
so try creating reusable measures and try to call them in the calculations. this would reduce the time significantlySQLBI have a pattern for ABC analysis which you can read about at https://www.daxpatterns.com/abc-classification/ .
They also have a library of functions, using the new user defined functions in public preview in the September 2025 update, which you can find at https://daxlib.org/package/DaxPatterns.AbcClassification/ .
Hi kianhaw98,
I would also take a moment to thank johnt75 , Praful_Potphode for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Regards,
Community Support Team.Hi kianhaw98,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Community Support Team.Hi kianhaw98,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.
Regards,
Community Support Team.
