Subgroups and categories in same table

Hi  danguy2099 ,

The Value of A's is 2: 23+12=35

Here are the steps you can follow：

1. Create calculated table.

Table_True =
var _summarize1=
SUMMARIZE(
    'Table',
    "Category","Subcategory(A+B+C)",
    "Sum",SUM('Table'[Value]))
var _table1=
UNION(
    'Table',_summarize1)
var _summarize2=
SUMMARIZE(
   _table1,
    "Category","Grand Total",
    "Sum",SUMX(_table1,[Value]))
var _table2=
UNION(
    _table1,_summarize2)
return
_table2

2. Create calculated column.

Value2 =
SWITCH(
    TRUE(),
    'Table_True'[Category] = "Subcategory(A+B+C)",
    CALCULATE(SUM('Table_True'[Value]),FILTER(ALL('Table_True'),'Table_True'[Category] in {"A","B","C"} )),
    'Table_True'[Category] = "Grand Total",
    CALCULATE(SUM('Table_True'[Value]),FILTER(ALL('Table_True'),NOT( 'Table_True'[Category]) in { "Subcategory(A+B+C)","Grand Total"} )),
    'Table_True'[Value]
)

3. Result:

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