Customize Subtotal in a Table/Matrix chart

To customize the subtotal in a Table/Matrix chart in Power BI, you can create calculated columns to represent the desired subtotals and then use them in the chart. Here's an example of how you could approach this:

1. Create a calculated column for the total income by using the following DAX formula:

Total Income = SUM(Table[Income] + Table[Other Income])

1. Create a calculated column for the difference between Income and Expense by using the following DAX formula:

Income - Expense = SUM(Table[Income]) - SUM(Table[Expense])

1. Create a calculated column for the difference between Income and Sales by using the following DAX formula:

Income - Sales = SUM(Table[Income]) - SUM(Table[Sales])

1. In the Table/Matrix chart, add the Total Income, Income - Expense, and Income - Sales calculated columns, and use them in the subtotals based on your requirements.

Note that this is just one example of how you could customize the subtotals in a Table/Matrix chart in Power BI. You can also use different DAX formulas or pivot the data to get the desired subtotals.