Forum Discussion
Select column based on selection from different table
Hi Everyone,
i have a table, which contains a overall Project overview:
ID | Name | TotalCost |
1 | P1 | 10 |
2 | P2 | 20 |
3 | P3 | 30 |
For each project, i have a detailed Project table:
Example Project1:
ID | CostPosition | CostAmount |
1 | Project Management | 4 |
1 | Development | 4 |
1 | Support | 2 |
Example Project2:
ID | CostPosition | CostAmount |
2 | Project Management | 5 |
2 | Testing | 2 |
2 | Support | 5 |
2 | Development | 8 |
Project Overview and the detailed project table are connected by the ID.
I want to create a Measure, which containts CostPosition and CostAmount of the Selected Project (from Poject Overview).
Any ideas how to do this? Is it possible to do it dynamically, so when i add more projects, i dont have to update the Measure?
Thanks for your help!
2 Replies
Hi Anonymous
if I understand you correct, you dont need any measures here.
It should be enough to create relationships between Project overview and Project tables one-to-many and add fields you need to visual
Hi Anonymous
you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.
