SUMPRODUCT as the Column Total

[dashmarley11]

I have a calculated field (%Expense) that's doing a simple division between two other columns, but I want to add a custom calculated SUMPRODUCT total for that field.  

This is the calculation for the custom measure:

%Expense = DIVIDE(SUM('Table1'[Rate_x_AvgBal]), SUM('Table1'[AvgBalance]))

However, for the Total of that column, I want to calculate the SUMPRODUCT and this is how I would otherwise do it in Excel:

SUMPRODUCT(%Expense, AvgBalance)/SUM(AvgBalance)

[Greg_Deckler]

@dashmarley11 Perhaps this (below). Comes from this: S Excel to DAX Translation - Microsoft Fabric Community

	
SUMPRODUCT = 
    VAR __Table = 
        ADDCOLUMNS(
            'Table1',
            "Value",[Value1] * RELATED(Table2[Value2])
        )
RETURN
    SUMX(__Table,[Value])

If not, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[dashmarley11]

@Greg_Deckler 

AccountKey	AvgBal	Rates
12345	138,480.04	0.15%
67891	69,703.41	0.25%
123437	1,470,382,559.42	0.35%
178983	-	0.45%
234529	0.02	0.55%
290075	75.00	0.65%
345621	325,591.12	0.75%
401167	5,022,422,224.80	0.85%
456713	11,498,835.71	0.95%

First, I need to create a new calculated field, which I have already solved for:

NewRate = SUM('Table1'[AvgBal]) * SUM('Table1'[Rates])

For the "Total" at the bottom of this new field "NewRate", I want to calculate a "SUMPRODUCT"

=SUMPRODUCT((AvgBal, Rates) / SUM(AvgBal))