Aggregate Count of Products per Order with Condition

[Ged]

Dear all,

I hope you are well. Seeking your help with a DAX formula after hours of googling in and out.

I have the following data situation:

• I have orders that can contain multiple products per order. 
• I was able to count the "No of Products per Order" using:

  CALCULATE(
      COUNT([OrderID]); 
      FILTER(Orders; [OrderID] = EARLIER('Orders'[OrderID])))

Order ID	Product ID	No of Products per order	Status	Expected result: No of 'Delivered' per Order
1	A	3	Delivered	3
1	B	3	Delivered	3
1	C	3	Delivered	3
2	A	3	Delivered	2
2	B	3	Delivered	2
2	C	3	In progress	2

• However, I'm struggling to calculate "Number of 'Delivered' products per order" . I have come to a conclusion that I need this in a calculated column for my further analyses.  
• I inserted the Expected result column.  
  • I did create some measures for this purpose, but they did not seem to yield the result I sought. 

I hope this makes sense.

Appreciate your wisdom

[parry2k · Accepted solution]

@Ged you can extend your existing dax formula to include only delivered

CALCULATE(
    COUNT([OrderID]); 
    FILTER(Orders; [OrderID] = EARLIER('Orders'[OrderID]) &&
   [Status] = "Delivered"
))

[Ged]

@parry2k 

Appreciate this, this is exactly something I had tried before posting here:

G_No of Hit per Order = 
                       CALCULATE(
                           COUNT(Table1[Order No]),
                           FILTER(Table1,Table1[Order No] = EARLIER(Table1[Order No]) && Table1[G_OTIF HIT/MISS]="HIT")
                       )

Column 'G_OTIF HIT/MISS' is my Delivery status in the example. 

Problem: the calculated column yields no results! Literally, all the cells are blanks. 

[Ged]

@parry2k 

Oh...It was 11pm when I was doing it last night, did not check the column values and understand that there will be blanks depending on the 'Delivery' status. (facepalm). 

Appreciate your answer, marking it as the solution!

Thanks