fulfilling a customer order from another stock of the same product

[Anonymous]

 

I want to do customer-based stock management for each product. In the data I have, there are real customers and dummy customers for each product. (The dummy customer actually means the customer who produces the product in stock.) 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.

[daXtreme]

Hi @Anonymous 

I'd kindly suggest you get familiar with this first: How to Get Your Question Answered Quickly - Microsoft Power BI Community

[Anonymous]

hi @daXtreme 
i take your suggestion and i am sharing a measure that i wrote. i hope it will help you understand the problem   

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])