Income Statement Matrix

[Anonymous]

Below I have a picture of a Matrix of an Incomestatement :  For Budget it is totaling correctly; however, I want expenses to be positive.  In actuals I flipped expenses to be positive; however, now the grand total is off.  How can I get it to where I have positive rev - positive exp = total?

[DataInsights · Accepted solution]

@Anonymous,

Try this solution:

1. Create calculated column:

Adjusted Actuals = IF ( FactTable[Main Type] = "Expenses", [Actuals] * -1, [Actuals] )

2. Create measure:

Actuals = 
IF (
    HASONEVALUE ( FactTable[Main Type] ),
    SUM ( FactTable[Actuals] ),
    SUM ( FactTable[Adjusted Actuals] )
)