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 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 

Need Help

2 Replies

  • 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])))