Filtering in Summarize

[Syndicate_Admin]

Good day I am working with a table created called OTIF Table to calculate fulfillments in complete deliveries and on time of purchase orders, I have created the OTIF Table with summarize where it brings me the PONumber Number, QuantityOrdered, QuantityReceived, DateReceived, EstShipDate but within this table I want to include a filter for the QuantityReceived column where I add the items received, only if the DateReceived date of these items is less than the EstShipDate date.

Annex table creation formula

OTIF Table = SUMMARIZE(PurchaseOrderDetail,PurchaseOrderDetail[PONumber],
"Qty Order",sum(PurchaseOrderDetail[QuantityOrdered]),
"Qty Received",sum(PurchaseOrderDetail[QuantityReceived]),
"Date Received",Max(PurchaseOrderDetail[DateReceived].[ Date]),
"ETA",Max(PurchaseOrder[EstShipDate].[ Date]))

[amitchandak]

@Syndicate_Admin , Change it like

"Qty Received",calculate(sum(PurchaseOrderDetail[QuantityReceived]),filter(PurchaseOrderDetail,PurchaseOrderDetail[DateReceived]<PurchaseOrder[EstShipDate]))

or after summarize

filter(

SUMMARIZE(PurchaseOrderDetail,PurchaseOrderDetail[PONumber],
"Qty Order",sum(PurchaseOrderDetail[QuantityOrdered]),
"Qty Received",sum(PurchaseOrderDetail[QuantityReceived]),
"Date Received",Max(PurchaseOrderDetail[DateReceived].[ Date]),
"ETA",Max(PurchaseOrder[EstShipDate].[ Date])), [Date Received]<[ETA] )