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
rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Hello muchtamo ,

You would need to create 3 measures as follows:

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

Total Plan = 
   CALCULATE ( SUM ( 'dbprojects tbl_t_project_impact'[plan] )

Total Monthly Forecast = 
VAR ActualSum = [Total Actuals]
VAR PlanSum = [Total Plan]
RETURN
IF (
    ActualSum  = 0,
    SUMX (
        'dbprojects tbl_t_project_impact',
        [Total Plan]
    ),
    SUMX (
        VALUES ( 'dbprojects tbl_t_project_impact' ),
        [Total Actuals]
    )
)

 

And then plot the last measure in the chart and see the results.
Please let me know if this didn't work.