Filter one table to have an effect in second calculated table

[JBrunetUdec]

Hi! I'm new to PowerBI and I haven't been able to find an answer to what I'm looking for:

I have a table that comes from excel, and from that table I generated another calculated table (with the DISTINCT function). The first table has a list of assets and costs associated with a date, and the calculated table has the average of costs for each asset:

What I want to create, is a slicer visual that changes the results of Table 2, by changing the range of the date considered, here is an example of what I need:

The most common response I get is that I should create a relationship between date fields in both tables, but table 2 has no date field. And just adding the slicer doesn't change the results of the second table.

How can I accomplish this? I know this may be a dumb question, but any help will be appreciated.

[BA_Pete · Accepted solution]

Hi @JBrunetUdec ,

You don't need to do anything clever here. Get rid of the calculated table as it's just taking up time and space.

Write a measure like this:

_avgAssetCost = AVERAGE(Table1[Cost])

 Then chuck it in a visual with Table1[Asset].

Pete