Sum by Category/Type without ignoring other filters

[PowerBIOrg]

Hi All, 

I would like to sum up the amount by Type. I know that ALLEXCEPT work in Scenario 1. 

Is there anyone can help to create a measure that could work for all scenario?

					Scenario 1	Scenario 2	Scenario 3	Scenario 4
				Filter 1 (Category):	All Selected	m	All Selected	m
				Filter 2 (Year):	All Selected	All Selected	2020	2021
Claim No	Type	Category	Year	Amount	Sum by Type	Sum by Type	Sum by Type	Sum by Type
a	x	l	2019	100	600	NA	NA	NA
d	x	m	2020	300	600	500	300	NA
e	x	m	2019	200	600	500	NA	NA
b	y	m	2021	100	200	100	NA	100
f	y	n	2021	100	200	NA	NA	NA
c	z	n	2020	100	100	NA	100	NA

Thanks!

[Jihwan_Kim · Accepted solution]

Hi, @PowerBIOrg 

Please check the below.

Sum by Type Measure =
CALCULATE (
SUM ( 'Table'[Amount] ),
ALLSELECTED ( 'Table' ),
VALUES ( 'Table'[Type] )
)

https://www.dropbox.com/s/sgydb85cmf1uuum/powerbiorg.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM