Summing a column in the same table for each row

**uziel9999** · 2014-03-27, 08:42 PM

Hello, I am trying to sum a column based on certain filters for every row in the table. The formula gives the total, but ignores the [Comp#] filter- $1,212,904 is the sum for everything; the formula should have given $75,598. Would someone please help by providing the correct syntax?

Code:

=CALCULATE(
                           SUM([Commission]), 
                           FILTER(
                                          tCommPerMonth,
                                               tCommPerMonth[Comp#]  =  RELATED(Data[Comp#]) 
                                          && tCommPerMonth[Date]     =  [Date] 
                                          && [WD Balance]                   <> 0 
                                          && ISBLANK([WD Balance])    =  FALSE()
                                          )
                           )

Click image for larger version.

Name: PP.png
Views: 40
Size: 14.9 KB
ID: 2176

Expected Output

Date	Commission
9/30/2013	$4,348
10/31/2013	$2,860
11/30/2013	$2,768
12/31/2013	$5,819
1/31/2014	$2,138
2/28/2014	$1,784
3/31/2014	$13,920
4/30/2014	$1,748
5/31/2014	$1,314
6/30/2014	$12,836
7/31/2014	$650
8/31/2014	$626
9/30/2014	$10,883
10/31/2014	$134
11/30/2014	$129
12/31/2014	$9,267
1/31/2015	$134
2/28/2015	$121
3/31/2015	$765
4/30/2015	$129
5/31/2015	$134
6/30/2015	$741
7/31/2015	$134
8/31/2015	$134
9/30/2015	$707
10/31/2015	$134
11/30/2015	$129
12/31/2015	$722
1/31/2016	$134
2/29/2016	$125
3/31/2016	$129
Total	$75,598