Multiply a Field by a Filter Range

Hi!

I am creating a forecast to determine if vendors are meeting or not meeting expected production (over or under) for their locations (lanes). My question is: how can I calculate the amount the vendors are over/under production within a time range (week number).

My expected production stays the same weekly. If I filter my slicer to look at multiple weeks' productions (say I filter for Week 28 - Week 32), I am comparing the total production from 5 weeks to the expected production of 1 week, when really, it should be the total production for 5 weeks compared to the expected production for 5 weeks. 

Therefore, how can I multiply my expected production against the distinct count of my filtered weeks?

I have 2 tables I'm using: 

1. Table 1: vendor, location, & expected production
2. Table 2: actual production, over/under amount, week number

My only join is a many-to-many, active relationship between table 1 & table 2 for the location.

Here is the current powerbi table and process I have: 

So again, I'm looking to have that Expected Production amount * filtered week range (7) = Over/under amount

As an excel file, this process (for 1 vendor) would look something like: 

• With the Actual Expected Weekly Production as: 
  • Actual Expected Weekly Production = Expected Production per Week * 2
  • Actual Over/Under = Actual Weekly Production - sum(C2 + C7) 
    • with C2 and C7 being the production of week 30 and 31 for Chicago - Tokyo