interactive inventory management

[Anonymous]

When a specific customer orders for a product, if the customer's stock of that product is insufficient, the order must be met from the dummy stock of that product. I also share a picture of how the table should be based on a single product. but i have much more product types.i am also sharing the sample output table for one product. in addition, i also add the measure that i wrote it but it does not work properly. i am glad that if you will help me:)

sample output:

measure:

measure=

var product=SELECTEDVALUE(table1 [productid])

var dummy=SELECTEDVALUE('dummytable'[productid])

var customer=SELECTEDVALUE(table1[customer])

return

 IF(urun= dummy && [ending]<0 && customer <> dummy ,[dummy stok],[ending])

[Anonymous]

hi @v-cazheng-msft , i havent solve my problem yet. i prepared dumb data i hope it will help. i tried to explain my problem. i can not share real data because the data owner does not allow it.
https://docs.google.com/spreadsheets/d/15HWaxPlVcxSHg08AroswCsym9NHktGW3/edit?usp=sharing&ouid=10840...

[v-cazheng-msft]

Hi @Anonymous,

May I know whether your issue has been resolved? If you still have problem on it, could you please provide some sample data from your tables and let me know their relationships? In addition, please make your needs more clearer. Thanks in advance!

Best Regards,

Community Support Team _ Caiyun