Calculation on Matrix table

Hi olofu,

Did these values analyze from attribute, value columns(attribute to matrix column field, value to matrix value field), or three value columns?

If you mean the first one, you need to calculate based on the Aree group and filter conditions:

Result =
CALCULATE (
    CALCULATE ( SUM ( Table[Value] ), [Type] = "RI" )
        + CALCULATE ( SUM ( Table[Value] ), [Type] = "RE" )
        - CALCULATE ( SUM ( Table[Value] ), [Type] = "CE" ),
    FILTER ( Table, [Area] = EARLIER ( Table[Area] ) )
)

If you mean the second one, you can directly create a calculated column to invoke these value fields to calculate:

Result =
Table[RI] + Table[RE] - Table[CE]

Regards,

Xiaoxin Sheng