Trouble with DAX and filter context

[Guitarmageddon]

Hello all, so I have a long list of SKUs and the purchase orders they have been ordered on. I'm getting a sense of SKU-level fill rate percentage.

I have added a measure for distinct count of items that the purchase orders were on. I'm trying to take it a step further : when I expand out the "style desc" column as you can see in row 8, how can I get the DAX to tell me the fill rate math (qty received divided by qty ordered) for the TOTAL parent PO, irrespective of whatever SKU I am looking at. So for example, when I expand out column C like Ive done here, it would show me the total fill rate for ALL items that PO had seen. Hopefully that makes sense. So basically, while I can see that PO 2260994 had a fill rate of 200% on that specific item, as a whole for all SKUs ordered,the PO fill rate could have been 50% lets say.


note: fill rate , distinct PO, are dax measures. The rest is source data.

and for a quick glimpse of source data, its like this

 

[Guitarmageddon]

I tried this , but obviously wrong, gave me an error. I think im sort of on the right track but cant get it
=CALCULATE(
[Sum of Qty Received]/[Sum of Qty Ordered],
FILTER(
Table1,Table1[PO ID])

EDIT: also, in doing some research, it looks like they do something similiar in this example, if you scroll down to the bottom screen shot. The distinction between revenue by total country vs region.

Examine filter context - Training

Learn how to examine filter context.

docs.microsoft.com

 

[Guitarmageddon]

ok i think i got something! Can I get someone to sanity check the method in case there is a better way?

I did t his method below. Basically used "ALLEXCEPT" which, as I understand, preserves all the filters I have set on the columns EXCEPT for anything placed on the PO. So basically, the total fill rate on ALL the orders and styles is 69% as you can see copied down, which is technically correct. But when I enter into an individual style, I can now see not just how that specific Purchase order/Style combo filled, but also the TOTAL fill for that PO across all the styles.