need help on how to take all rows for an item into account.

[DustinD]

i have made a mock up of what my table looks like. so my goal is to take remsales minus onhand for a item and return y or n if we can cover all orders. so for example below 432-10 is in the table 2 times. when test runs which is what im using to show what im looking for. i want it to take all orders for a part not just a row level. the first item in the chart can be coverred but at the bottom we see the item again and we do not have enough to cover both orders so it should return n for that item number. 

[DustinD]

this worked exactly how i wanted. thanks 

[FreemanZ · Accepted solution]

hi @DustinD ,

try to add a calculated column like:

Test2 = 
VAR _t = FILTER(data, data[Item]=EARLIER(data[Item]))
VAR _r = SUMX( _t, data[Resales])
VAR _o = MAXX( _t, data[On-Hand])
RETURN
IF(_o>=_r, "y", "n")

it worked like:

[DustinD]

will evrey row having its own order number effect using this dax? @FreemanZ 

[FreemanZ]

no, it won't. just try and let us know.