Creating MEASURE: need to divide Team total by Manager Quota

[pete234]

I managed to connect my sales table pivot to a quota query feeding from Access.
Manager Quota Qtr repeat in the data at team level in my normal week view.
I know I could create a measure to see what % of the Manager's quota a rep contributed to
but how do I create a measure of the team total sales to manager quota?

The layout is by weekly sales can anyone suggest a measure for this?

The fields are:
1)Manager 1a)Team 2)Rep Name 3)Mgr Qta Qtr (repeats) 4)Rep Qta Wk 5)Sales Total Week rep level

thanks

 

[powerpivotpro]

Is this all one table? I can't quite decipher your nomenclature for columns and tables.

 

[pete234]

Hi, this is one pivot table SalesKPI so rows Manager, Team, Rep Name, values are the rest.
This is connected to my DateDim table and my RepTable, related to ClosedBusiness(name) and QuotaQry (Date and Name).
I've just started on measures in the Dax Formula book as I've done more calculated columns at this point.
But now I realized that what I need is the sum of the team sales for the current quarter to compare to the manager quota at the quarter.
So I think I'd need to filter on current quarter, with the weeks below and have a table level running total on sales?
Then divide this by Manager quota?
This may seem weird but keep in mind, my users can't use this workbook so I copy out the big table back to regular Excel.