Aggregated Total using a Distinct Totals

[ae19bu]

Hello PBI Community, 

I need help to figure out how I can calculate a Aggregated Total using Distinct Totals.  Specifically , the Denominator to calculate a Percent of total. Unfortunately , my table has duplicates so I tried the following:

VAR Asum=

SUMX(

SUMMARIZE(

VALUES(Table1[AcctNum])

,Table1[AcctNum]

,"ABCD"

,MIN(Table1[Amount])

) ,[ABCD] )

RETURN
SUMX(ALL(Table1[Column1]), Asum )

[ae19bu · Accepted solution]

I figured it out. Here is the formula that worked for me. 

VAR Asum=

SUMX(

SUMMARIZE(

VALUES(Table1[AcctNum])

,Table1[AcctNum]

,"ABCD"

,MIN(Table1[Amount])

) ,[ABCD] )

RETURN
CALCULATE(Asum, ALL(Table1(Column1))