subtracting the Column totals in a matrix visual power bi

[Anonymous]

I have the following rows in my excel sheet

When I import the excel sheet to Power BI, I was able to use the matrix table to get the sub total portion of the above sheet by including the totals and subtotals on for the matrix visual. Below is my rendition of the excel sheet in Power Bi

My issue is I need to calculate the 'Gap' between the 'Sub-total' and the 'Available Resources' which I can easily calculate in excel but have no idea how to implement it in Power BI, If I include the 'Available Resources' row in Power BI, the totals are all wrong as it calculates all the rows combined totals to display. Any ideas or suggestions will help. Thanks

[v-chuncz-msft]

@Anonymous,

A complete example would be better. You may try to add a calculated table.