Calculating ABC over different product categories

realexander- I've been taking a look at this and I've been thinking about an ABC measure for quite a bit. Problem that I see is that there is no way to dynamically sort a temp table in a DAX variable that I can find. I believe this would be needed to dynamically do an ABC calculation like what you are trying to do. So, I believe at this point that you would need to create a "static" calculated table for each ABC analysis that you want to do, sort it and then put in your calculated columns. Not optimal. I've reached out to a few folks on this and will post back here if I find out some trick for this.