Create Table from measures

Hi, Anonymous ;

Such as yogesh14june said, you could merge in power query.

way 1. merge in power query.

way 2: create a new table by dax.

New table = 
var _a=UNION(VALUES('Project 1'[Engineer Name]),VALUES('Project 2'[Engineer Name]))
return  ADDCOLUMNS( SUMMARIZE(FILTER(_a,[Engineer Name]<>BLANK()),[Engineer Name]),
"Project 1 Task", CALCULATE(SUM('Project 1'[#Task Assigned ]),FILTER('Project 1',[Engineer Name]=EARLIER('Project 1'[Engineer Name]))),
"Project 1 Task Delayed", CALCULATE(SUM('Project 1'[#Task Assigned ]),FILTER('Project 1',[Engineer Name]=EARLIER('Project 1'[Engineer Name]))),
 "Project 2 Task",CALCULATE(SUM('Project 2'[#Task Assigned]),FILTER('Project 2',[Engineer Name]=EARLIER('Project 1'[Engineer Name]))),
 "Project 2 Task Delayed",CALCULATE(SUM('Project 2'[# Task Delayed]),FILTER('Project 2',[Engineer Name]=EARLIER('Project 1'[Engineer Name]))))

the final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.