Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Proud to be a Datanaut!
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
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.