Forum Discussion
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
- BA_PeteSuper User
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