Help required to create a new percentage measure from multiple data sources.

[bix]

Dear Supporters, 

Please help me to create new percentage from multiple data sources. 

Such as, I have more than two projects, I want to get commulative percentage for all projects. 

Cloud Data Source: Project A:       Column Name: Completion: 25%

Cloud Data Source: Project B:       Column Name: Completion: 45%

Cloud Data Source: Project C:       Column Name: Completion: 65%

How I can get, overall projects completion percentage?

Looking forward for support. 

[garvicasas]

Si if i understand it correctly in Source 1 there is Project A you have 25% of completition of this one, project B the same in source 2 with 45% completition and you want a char that shows all this persentatges?

[bix]

Yes, Exactly. 

So I can use with Cards or with Charts. 

[garvicasas]

then i would make a relationship with all of them. Maybe creating it in a variable common in all, which seems no problem for u since all are the same type(projects) or better, create a table projectManager and then make a relationship of all the projects to this. Then all will work

[Anonymous]

If the tables in the different sources have the same columns I would merge all them in Power Query and make it a single table. You can do this wiht the Merge Queries option

[garvicasas]

that's true, but maybe some projects have some columns the other projects doesn't have, but still there are columns in common; then my option would be better

[bix · Accepted solution]

Hi Garvicasas, 

Thanks for your inputs and suggest to create new table. But instead of create the relationship, I used the following mechanisam to get the result. 

TableName = Union(SelectColumns("DataSource-ProjectA',"Project Name",'Datasource-ProjectA'[ProjectName],'DataSource-ProjectA,"Completion",'DataSource-ProjectA'[Completion]),

SelectColumns("DataSource-Project-B',"Project Name",'Datasource-Project-B'[ProjectName],'DataSource-Project-B"Completion",'DataSource-ProjectA'[Completion]))