Forum Discussion

JBrunetUdec's avatar
JBrunetUdec
Frequent Visitor
3 years ago
Solved

Filter one table to have an effect in second calculated table

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.

 

  • 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

1 Reply

  • 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