Calculated column based on date slicer selection

Hi folks,

I just read the following article (http://community.powerbi.com/t5/Community-Knowledge-Base/Calculated-Column-Table-Change-Dynamically-According-to-Slicer/ta-p/163321) which makes me believe what I am trying to do is not possible but nevertheless, I'll ask :)

I have one table (Transactions) with multiple transactions which include 11 columns with different possible manufacturers, a "Total Price" for each line and a transaction date.

I have another table (Manufacturer) where I have a distinct list of all manufacturers and I'd like to have against them, a sum of the "Total Price" to plot. The catch is that I'd like to use the Transaction Date of the first table as a slicer, and after hours of trying, I'm close to giving up.

At the moment, my calculated column is based on the following:

Total Spend = CALCULATE (
              SUM(Transactions[TOTAL PRICE]),
              FILTER(Transactions,Transactions[Related Manufacturer 1]=Manufacturer[Manufacturer]||Transactions[Related Manufacturer 2]=Manufacturer[Manufacturer]||Transactions[Related Manufacturer 3]=Manufacturer[Manufacturer]||Transactions[Related Manufacturer 4]=Manufacturer[Manufacturer]||Transactions[Related Manufacturer 5]=Manufacturer[Manufacturer]||Transactions[Related Manufacturer 6]=Manufacturer[Manufacturer]||Transactions[Related Manufacturer 7]=Manufacturer[Manufacturer]||Transactions[Related Manufacturer 8]=Manufacturer[Manufacturer]||Transactions[Related Manufacturer 9]=Manufacturer[Manufacturer]||Transactions[Related Manufacturer 10]=Manufacturer[Manufacturer]||Transactions[Related Manufacturer 11]=Manufacturer[Manufacturer]
              )
              )

Does anyone have any clever idea on how to filter the amount this calculation returns based on a slicer for a date on table1?