Forum Discussion

muchtamo's avatar
muchtamo
New Member
5 years ago

Total column matrix are incorrect

Mohamad Muchtar Mohamad Muchtar 5 minutes ago Hello , I've problem with my dax formula, column totals are not equal to monthly total Forecast1 = if( CALCULATE(sum('dbprojects tbl_t_project_impact'[act...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi muchtamo ,

 

We usually use the SUMX function or the HASONEVALUE function to solve the problem of incorrect matrix Subtotals.

Try this

Total Actuals =
SUM ( 'dbprojects tbl_t_project_impact'[actual] ) 

Total Plan = 
SUM ( 'dbprojects tbl_t_project_impact'[plan] )
Forecast1  = 
IF (
     [Total Actuals] = 0,
    SUMX (
        'dbprojects tbl_t_project_impact',
        [Total Plan]
    ),
    SUMX (
         'dbprojects tbl_t_project_impact' ,
        [Total Actuals]
    )
)

 

Reference: DAX – Subtotals and Grand Totals That Add Up “Correctly”

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.