Help with measure - combining 2 categories into 1

[RichOB]

Hi, I'm looking to combine 2 general ledger codes to make 1 code/1 figure but my measure is not working. 

I have 2 tables. first is Category_Table:

GL Code	GL Code Name
4202	RI
4201	RCI

The £ table is called Amount_Table

GL Code	Amount
4202	£300
4201	£100

What measure will make a code called GLCombined with £400 in one table?

Thanks

[bhanu_gautam · Accepted solution]

@RichOB , You can use below measure

GLCombinedAmount =

CALCULATE(

    SUM(Amount_Table[Amount]),

    Amount_Table[GL Code] IN {4201, 4202}

)

If you want to create a new table with the combined GL code and amount

GLCombinedTable =
SUMMARIZE(
FILTER(
Amount_Table,
Amount_Table[GL Code] IN {4201, 4202}
),
"GL Code", "GLCombined",
"Amount", SUM(Amount_Table[Amount])
)