Help needed DAX formula for calculating inventory coverage

[redalert787]

Hello, 

I posted this earlier but I never got a response. I'm wondering if any DAX wizards can help with the below:

I work for a retailer and am building a dashboard to help model inventory coverage based on our inventory and sales. I am using power query/ power pivot but I'm not too familiar with DAX functions so I was hoping I could get some help here. 

The basic calculation I would like to do is for inventory coverage that I can bring into a pivot table. We calculate inventory coverage as: inventory/(sales for last 4 weeks/4). 

Ideally, the equation of inventory coverage just because a formula that I can look at in the pivot table across stores or across product category etc. I'm just having a hard time getting the calculation in DAX. It would be a pretty simple one in calculated formulas in a normal pivot table so if someone can guide me in the right direction, I would really appreciate it. 

here is a link for a sample data set of what I am using showing the sales and inventory of the stores and warehouse: 

https://amersportsonline-my.sharepoint.com/:x:/g/personal/ardi_sardashti_amersports_com/EeSjobC4xgZF... 

Here's an example of the pivot table currently: 

[AllisonKennedy]

@redalert787  Sorry, I'm not sure what you're trying to do? The pivot table you posted - that is just a simple matrix visual in Power BI, but I don't think that's the final result you're looking for?

How do you know which Warehouse relates to which Sales/Stores? 

Also, in your sample file the Total Inventory column is empty?

Please provide desired output, and sample values for all columns of data and we can help better.