Forum Discussion

olofu's avatar
olofu
Frequent Visitor
4 years ago
Solved

Calculation on Matrix table

Hello to everyone, I would like to obtain some calculation on PowerBI I created a matrix with 3 data columns (RE, RI, CE)  and I would like to have a new column with a calculation (RI+(RE-CE)...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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