Divide sum of one column by sum of another column with applied slicer

[Anonymous]

I have the below data table. 

Loan Number	Loan Amount	Divisional bps	Div Concession $	Actual Div BPS
1707292	$1,094,180	0.5	$5,470.90	0
1801566	$456,300	1.12	$5,110.56	0
1802860	$340,000	1.391	$4,729.40	0
1801866	$843,406	0.45	$3,795.33	0
1803235	$502,500	0.75	$3,768.75	0
1801466	$679,650	0.527	$3,581.76	0
1801730	$300,000	1.115	$3,345.00	0
1715250	$222,400	1.504	$3,344.90	0
1707887	$1,000,000	0.332	$3,320.00	0
	$5,438,436		$36,466.60

For actual DIV BPS i'm using the below calculation: 

Actual Div BPS = SUM('LoanMaster (2)'[Div Concession $])/Sum('LoanMaster (2)'[Loan Amount])

It's not pulling correctly when I have either a Date or Sales Person Slicer applied. Not sure how to get this to work. 

[Anonymous · Accepted solution]

Figured it out! had to do Measures not columns! 1 for each total then divide!