SUMPRODUCT to Create Output for Matrix Visual

[dashmarley11]

I already have "Table 1" and "Table 2" setup and I need to use SUMPRODUCT to derive output to then use in a Matrix visual.  The SUMPRODUCT formula is:  =SUMPRODUCT($A$2:$A$36, $D$2:$D$36, AA$2:AA$36) / SUMPRODUCT($A$2:$A$36, AA$2:AA$36).  This will solve for the "12" term in 'Table 2' and will be the same for each of the other terms in Table 2 (24, 36) by moving the column lookups in 'Table 2' (AA, AB, AC).

Table 1

A          B             C            D

Term	Base Rate	TLP	FTP Rate
1	5.32%	0.17%	5.49%
2	5.33%	0.17%	5.50%
3	5.33%	0.17%	5.50%
4	5.32%	0.17%	5.49%
5	5.32%	0.17%	5.49%
6	5.31%	0.17%	5.48%
7	5.30%	0.18%	5.47%
8	5.28%	0.18%	5.47%
9	5.27%	0.19%	5.46%
10	5.26%	0.20%	5.45%
11	5.24%	0.20%	5.45%
12	5.23%	0.21%	5.44%
13	5.20%	0.22%	5.42%
14	5.18%	0.23%	5.40%
15	5.15%	0.23%	5.38%
16	5.12%	0.24%	5.36%
17	5.09%	0.25%	5.34%
18	5.06%	0.26%	5.32%
19	5.04%	0.26%	5.30%
20	5.01%	0.27%	5.28%
21	4.98%	0.28%	5.26%
22	4.95%	0.29%	5.24%
23	4.92%	0.29%	5.22%
24	4.90%	0.30%	5.20%
25	4.88%	0.30%	5.18%
26	4.86%	0.31%	5.16%
27	4.84%	0.31%	5.15%
28	4.82%	0.32%	5.13%
29	4.80%	0.32%	5.12%
30	4.78%	0.33%	5.10%
31	4.76%	0.33%	5.09%
32	4.74%	0.33%	5.07%
33	4.72%	0.34%	5.06%
34	4.70%	0.34%	5.04%
35	4.68%	0.35%	5.03%
36	4.66%	0.35%	5.01%

Table 2

AA            AB              AC

12	24	36
81,441	39,705	25,804
81,780	39,870	25,912
82,121	40,036	26,020
82,463	40,203	26,128
82,807	40,371	26,237
83,152	40,539	26,346
83,498	40,708	26,456
83,846	40,877	26,566
84,195	41,048	26,677
84,546	41,219	26,788
84,899	41,390	26,900
85,252	41,563	27,012
-	41,736	27,124
-	41,910	27,237
-	42,085	27,351
-	42,260	27,465
-	42,436	27,579
-	42,613	27,694
-	42,790	27,810
-	42,969	27,926
-	43,148	28,042
-	43,328	28,159
-	43,508	28,276
-	43,689	28,394
-	-	28,512
-	-	28,631
-	-	28,750
-	-	28,870
-	-	28,990
-	-	29,111
-	-	29,232
-	-	29,354
-	-	29,477
-	-	29,599
-	-	29,723
-	-	29,847

[Greg_Deckler · Accepted solution]

@dashmarley11   S Excel to DAX Translation - Microsoft Fabric Community