Forum Discussion
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 ...
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
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