Accessing column data from a virtual table, or building a base table? (Pareto Chart)|Power Pivot|Excel Forum|My Online Training Hub

This is an extension to an earlier issue on a different forum. (https://community.powerbi.com/.....909#M41327)

I have a table that has many columns, but for the purposes of this example looks like this (call it Order Table)

In my measure I create a Summarized table which tells me how many times an Item Code occurs in the above table. Effectively how many orders are using that Item Code. So based on the above it would look like this;

The above is therefore a virtual table in my Measure on the Order Table. The DAX to create the virtual Table is as follows

VAR ItemTable= SUMMARIZE(ALLSELECTED(OrderTable), OrderTable[Item Code], "Occurs", DISTINCTCOUNT(OrderTable[Order Id]))

What I want to do in my Measure now is access this virtual table to find the 'Occurs' value for the Item Code in the current context. The context being based upon OrderTable because that is where the measure is.

The long term intention is to create a measure that allows me to build a Pareto Graph, but I think my strategy is wrong because the data for the graph is largely in the virtual table. My virtual table just needs a cumulative sum of the Occurs column, built in descending order of that column. I think I need to create another base table, probably using Power Query, then use that new table to make my chart.

I would appreciate some advice / guidance please.

TIA