Sales Filtering by a Measure

Hello Everyone, 

Firstable, thank you in advance for help. I will to be the more clear as I can.

Here the context. I need to calculate the sales per group of stores which are rattached to a warehouse. To do this, I have several warehouses and each stores is rattached to only one of them. 

To make it simple, let say, we have 2 warehouses (W_A and W_B) and 8 (Store 1, Store 2.... Store 8) stores. And in my world:

• Each warehouse order its products to the suppliers. 
  
• Then, the stores order the product to the warehouse.
• The point is that the warehouse order its quantity depending on the sales of stores which are rattached to them. 
• That's why i need to split the sales between the warehouse

Today I can identify which stores is rattached to which warehouse and I have all sales for all stores per products, thanks to a measure. 

• This measure let me identified the stores rattached the warehouse : 

CONCATENATEX(VALUES(Data_Order[No Store]);Data_Order[No Store];", ")

Below, you can find how is build my sales table:

To resume in one sentence :  I want to know the sales of the stores that are rattached to the warehouse. Below and a last example :

• My stores 1, 2 and 3 are rattached to the warehouse A. And, therefore ordering to the warehouse A. 
• Also, note that I'm finding which Store order to which warehouse thanks to a measure.
• I need to know the sales of the stores 1, 2 and 3 in order to know how much the warehouse have to order to the supplier. 
  

And the measure I already tried (The first part is for calculate the monthly sales:

   CALCULATE(AVERAGEX(VALUES(LookUp_Calendar[YYYYMM]);[Quantity Sold]);FILTER(Data_Sales;VALUES(Data_Sales[No Stores]))))

Thank you and have a great day

Erwan