Select column based on selection from different table

[Anonymous]

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!

[v-diye-msft]

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.

[az38]

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