Filter Date Table (by dates in another table and production line)

[EdwardChurches]

Hi everyone,

I'm struggling with a formula to create the average quantity produced in a production line. I started with this formula to count the days the we actually worked:

countrows(calculatetable(dDate,filter(dDate,dDate[Day Of Week]<>"domingo"&&dDate[Date]<=lastdate(all(fProduction[Producción])))))

The formula works fine; it basically takes away Sundays. Here's the problem. I just got a new table with dates that should be taken away from the average (the dates are different depending on the production line).

I have no idea how to do this. Any suggestions?

(Hope I was able to explain my issue clearly)

[amitchandak]

@EdwardChurches , Assume Your measure name is M1, which you created above you can try

AverageX(Values(Table[ production line]) , [M1])