Add new calculated rows in matrix

Hi eduardosilvin3 

Since you need to add more rows with new calculations in the matrix, you may need to make those calculations in advance and union the results to your current calculated values. Then use data from the new table into the matrix. An example: 

new table =
VAR _table1 =
    SUMMARIZE (
        'DB Sales',
        'DB Sales'[Index],
        'DB Sales'[invoice_no],
        'DB Sales'[invoice_date],
        "new column 1", SUM ( 'DB Sales'[item_net_value] ),
        "new column 2", SUM ( 'DB Sales'[Sub Revenue] )
    )
VAR _table2 =
    SUMMARIZE (
        'DB Sales',
        'DB Sales'[Index],
        'DB Sales'[invoice_no],
        'DB Sales'[invoice_date],
        "new column 1", SUM ( 'DB Sales'[item_TotalCost] ),
        "new column 2", SUM ( 'DB Sales'[Sub Cost] )
    )
VAR _table3 =
    SUMMARIZE (
        'DB Sales',
        'DB Sales'[Index],
        'DB Sales'[invoice_no],
        'DB Sales'[invoice_date],
        "new column 1", SUM ( 'DB Sales'[item_net_value] ) - SUM ( 'DB Sales'[item_TotalCost] ),
        "new column 2", ..........
    )
RETURN
    UNION ( _table1, _table2, _table3 )

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!