Power BI Dax - Row Summary of multiple measures using Row function of Summarized column or Sumamrized table

Hi All
I am struggling with one issue and need your kind support/guidance
I have three tables within my PBIX file
Table1: ‘Data’ with fields order date, group name and revenue field
Table2: Group Type (referenced from ‘Data’ and DTD_GRP2 measure
Table3: Group Type (referenced from ‘Data’ and DTD_GRP3 measure
Requirement:
I want to summarize the results from multiple tables into one table using DAX.
Option1: Using Row Function using filter option using measures
NewTable =
ROW (
Group1", CALCULATE ( sum(' Group1'[DTD_GRP2], ' Group1'[Group Type] = "Group1" ),"Group2", CALCULATE ( sum(' Group2'[DTD_GRP2], ' Group2'[Group Type] = "Group2" )
Option 2: Summarize Columns of Summarize Tables using lookup / filter option
I have been stuck and tried writing DAX using row function, summarize column and/or summarize table
Need support if some one can help me sharing any dax or let me know what function can be used to summarize the group information by calling or referencing multiple measures from multiple groups
Output expected
Need to generate a row level summary , using ROW function or Union of summarized tables