DAX Filtering with 2 related tables?

DAX DAX Calculations
1

Good evening, I am pretty new to using DAX formulas, so therefore this question:

Is it possible to calculate an average, based upon filtering of 2 related tables ? **)
Or better find other ways to do this ?

Can I somewhere calculate an average defects per day, based upon predefined fixed 8 months in the past **), by a code like this AverageX (Total Quantities x Total Defects, both filtered by DateT [Year&Month] > = StaticFCPeriod [EndYearMonth] and DateT [Year&Month] < = StaticFCPeriod [EndYearMonth]
The StaticFCPeriod table gives a starting and ending period per month, for the static 8 months average.

See also attached PBIX, thanks in advance for any guidance and or code.
SPC File DS.pbix (121.1 KB)

**) This question came up by me trying to resolve a problem on the forum from today “Month Fixed Mean Period”, which is already solved by Melissa.

2

Hi @deltaselect! We noticed that your inquiry was left unsolved for quite some time now. We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!