Countif multiple conditions met

Thank you for the reply and time you put into this. 

What you created is right for my description of problem, I can see how it led you to that direction. 

Here is a version of if that might help what I am trying to do. 

In my data set (bill of materials) there is 1020 lines items. The same part number may show up multiple times. So I should consolidate the data down to sum up all the same part numbers and pull that into power bi.. but if I were to avoid doing that and let power bi do it for me in a measure, it would be great. 

So.. as you can see 133717 - Gusset Plate A shows up twice, as does other gusset plates. 

I want the measure to sum up the unique part numbers so it would know I require 75 Gusset Plate A - Part # 133717. 

These items are a purchase part. You can see in the data set there is a Prod. Order part mixed in. 

So I am trying to make the measure

- sum up the same part numbers

- are purchase items

- then the qty I require would be compared to my current stock level. If the result is less than 0, it would count the number of less than 0 lines to tell me I am short 245 different part numbers out of the fill list of 1020.

133717 - Gusset Plate A  - 75 Required. 0 in stock  =  -75   <-- short 75, is less than 0 so result would be 1 as in 1 item is short out of 1020 lines. 

just want to get a pulse on how many items in the whole project are still outstanding.