Matrix Subtotal Adding up matrix rows

[Wcys02]

Hi, 

How does one subtotal a forecasted data and actual data in a matrix? Currently the subtotal auto calculated by powerbi is only showing actual figures for Jan-June but not including forecasted figures for July.

I'm using to the following logic to get powerbi to choose between forecasted and actual data:

Actual/Fc = IF(SUM('Table 1 -Actual'[Value])=0,SUM('Table 2 - Forecasted'[Value]), SUM('Table 1 - Actual'[Value]))

 thanks in advance 

[olgad]

Hi, change totals using if(hasonevalue(name of the month column), IF(SUM('Table 1 -Actual'[Value])=0,SUM('Table 2 - Forecasted'[Value]))+SUM('Table 1 - Actual'[Value]), IF(SUM('Table 1 -Actual'[Value])=0,SUM('Table 2 - Forecasted'[Value]), SUM('Table 1 - Actual'[Value])))

[Wcys02]

Hi, sry I was not clear, the total column is using the subtotal settings in Powerbi.

Link to sample file: https://we.tl/t-01SBV27ftn