Create abberanding total

[MiKeZZa]

Is it possible to create an abberanding total in a matrix? This for bookkeeping purpopes?

What I have now is (red is wrong):

Revenues:

    Revenue 1                  1.000

    Revenue 2                  2.000
    Total Revenues:          3.000

Costs:
    Cost 1                         1.000 

    Cost 2                           400 

    Total Costs:                1.400

TOTAL:                           4.400

What I want is Total to be 1.600 (3000 - 1400), but without having the Costs also as a negative value. What I was able to create is (red is wrong):

Revenues:

    Revenue 1                  1.000

    Revenue 2                  2.000
    Total Revenues:          3.000

Costs:
    Cost 1                         -1.000 

    Cost 2                           -400 

    Total Costs:                -1.400

TOTAL:                           1.600

What I want: 

Revenues:

    Revenue 1                  1.000

    Revenue 2                  2.000
    Total Revenues:          3.000

Costs:
    Cost 1                         1.000 

    Cost 2                           400 

    Total Costs:                1.400

TOTAL:                           1.600

But I was not able to create this....

Who can help me?

[Vvelarde · Accepted solution]

hi @MiKeZZa

you can create a new measure to obtain this result:

ValueRV =
VAR REVENUE =
    CALCULATE ( SUM ( Table1[Value] ), Table1[Type] = "REVENUE" )
VAR COSTS =
    CALCULATE ( SUM ( Table1[Value] ), Table1[Type] = "COSTS" )
RETURN
    IF (
        HASONEVALUE ( Table1[Type] ),
        CALCULATE ( SUM ( Table1[Value] ) ),
        REVENUE - COSTS
    )

And Use it in values Section in Matrix Visual.

[MiKeZZa]

This works like a charm! Thank you!