Forum Discussion

Wcys02's avatar
Wcys02
Frequent Visitor
3 years ago

Matrix Subtotal Adding up matrix rows

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 f...
Need Help
olgad's avatar
olgad
Resident Rockstar
3 years ago

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's avatar
    Wcys02
    Frequent Visitor
    3 years ago

    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