New Table in Table View

Hi  Ralpho93 ,

I created some data:

Sort the ABCD table sequentially from left to right

Here are the steps you can follow：

1. Create calculated table.

True =
var _table1=
FILTER(
    'TableA','TableA'[Group] in {"B","C"})
var _table2=
SUMMARIZE(
    _table1,[ID],[Group],"Value",
    IF([ID] in SELECTCOLUMNS('TableB',"id",'TableB'[ID])&&[Group] in SELECTCOLUMNS('TableB',"group",'TableB'[Group]),
    SUMX(
        FILTER(ALL(TableB),
        'TableB'[ID]=EARLIER([ID])&&'TableB'[Group]=EARLIER([Group])),'TableB'[Value]),
    SUMX(
        FILTER(ALL(TableA),
        'TableA'[ID]=EARLIER([ID])&&'TableA'[Group]=EARLIER([Group])),'TableA'[Value]))) //2
var _table3=
SUMMARIZE(_table2,[ID],[Group],"Value",
    IF([ID] in SELECTCOLUMNS('TableC',"id",'TableC'[ID])&&[Group] in SELECTCOLUMNS('TableC',"group",'TableC'[Group]),
    SUMX(
        FILTER(ALL('TableC'),
        'TableC'[ID]=EARLIER([ID])&&'TableC'[Group]=EARLIER([Group])),'TableC'[Value]),
    SUMX(
        FILTER(_table2,
        [ID]=EARLIER([ID])&&[Group]=EARLIER([Group])),[Value])))
return
UNION(
    _table3,'TableD')

2. Result:

If it doesn't meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly