Divided functions

[Witthawat]

How can I calculate each FO number / Receiving Qty.?

I received 15,000 but found  4 foreign bodies as the table below.  It works only with Bone but others didn't work.

Receiving Date

Item Code

RM Name

Est.

Supplier name

Killing date

Cutting date

Condition

Lot

Sublot

Receiving Qty.

FO type

FO Num

11-Jul-22

231100152

RM A

100

A

5/7/2022

Frozen

187

10

15000

Bone

23

11-Jul-22

231100152

RM A

100

A

5/7/2022

Frozen

187

10

Stone

1

11-Jul-22

231100152

RM A

100

A

5/7/2022

Frozen

187

10

Feed-Corn

3

11-Jul-22

231100152

RM A

100

A

5/7/2022

Frozen

187

10

Plastic

1

[tamerj1 · Accepted solution]

Hi @Witthawat 
Here is a sample file with the solution https://www.dropbox.com/t/qij84hgljVePXolp

FO number / Receiving Qty = 
DIVIDE (
    CALCULATE ( 
        SUM ( Data[Receiving Qty] ), 
        ALLEXCEPT ( Data, Data[Item Code], Data[Receiving Date], Data[Supplier name] ) 
    ),
    Data[FO Num]
)