Remove filter only on rows to sum but keep context filter

[art12345]

Hi all, 

I hope you can help me with the following. 

I have the following data set. 

Loan	Region	Borrower	Amount
A	EU	Company A	100
B	EU	Company B	200
C	US	Company C	300
E	ASIA	Company D	400
F	ASIA	Company E	500
G	ASIA	Company D	600

I want to create a measure that calculates the sum of "Amount" based on Region. The complicating factor is that I want to caculate it based on the Loan selected in a drop down. So for eample, after selecting Loan E, I want the result to be 1500. The Loan E is in ASIA and the total amount for that Region is 1500. 

I need something similar with Borrower, but the concept will be the same. 

I tried the following: Measure = Calculate( Sum(Data[Amount]), Removefilter(Data[Loan]), Data[Region] = Data[Region])

I think the Removefilter is making me lose the Data[Region] used to filter the Sum(Data[Amount]) but i dont know how to solve that. My searches so far did not get anywhere. 

Many thanks!

[art12345]

This works! Many thanks. 

(Small edit needed at the end I think "... Data[Region] = Region"

[JamesFR06 · Accepted solution]

HI

Var Region=selectedvalue(Data[Region])

return

Calculate( Sum(Data[Amount]), Removefilter(), Data[Region] = Data[Region])