Summation During Filtering

[ALGH08]

Hello all

I have a dataset similar to below.  

Year	Category	# Instances
2021	A	15
2021	B	15
2021	C	15
2022	A	10
2022	B	20
2022	C	30
2023	A	45
2023	B	39
2023	C	24

I want to be able to filter for 2023 and see something similar to the output below

Category	2023 Instances	Total Aggregated Instances
A	45	70
B	39	74
C	24	69

Thanks in advance!

[amitchandak]

@ALGH08 , Try two measure like

M1= sum(Table[Instances])

M2= calculate( sum(Table[Instances]) , removefilters(Table[Year]))