Forum Discussion
Solved
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 (12...
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/ .
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 significantly