jabrilloHelper I3 years agoSolvedMatrix - Wrong Total I want to create this matrix: Q1 Q2 Q3 Q4 Total Planned 10 10 10 10 40 Actual 5 7 12 Estimate by EOY 5 7 10 10 32 Data Planned Table Project Qua...Show Moretamerj13 years agoHi jabrillo You can try Estimate by EOY = SUMX ( VALUES ( TableName[Quarter] ), CALCULATE ( IF ( [Actual] > 0, [Actual], [Planned] ) ) )
tamerj13 years agoHi jabrillo You can try Estimate by EOY = SUMX ( VALUES ( TableName[Quarter] ), CALCULATE ( IF ( [Actual] > 0, [Actual], [Planned] ) ) )
tamerj13 years agoHi jabrillo You can try Estimate by EOY = SUMX ( VALUES ( TableName[Quarter] ), CALCULATE ( IF ( [Actual] > 0, [Actual], [Planned] ) ) )
tamerj1Community Champion3 years agoHi jabrillo You can try Estimate by EOY = SUMX ( VALUES ( TableName[Quarter] ), CALCULATE ( IF ( [Actual] > 0, [Actual], [Planned] ) ) )
Related contentWrong TotalColumn Grand Total in Matrix is wrongWrong Total in TableTotals in MatrixMatrix Visual Total Wrong
