Forum Discussion

ae19bu's avatar
ae19bu
Frequent Visitor
6 years ago
Solved

Aggregated Total using a Distinct Totals

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 )

All()
DAX
Summarize()
Sumx()
  • ae19bu's avatar
    ae19bu
    6 years ago

    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))

1 Reply

  • ae19bu's avatar
    ae19bu
    Frequent Visitor
    6 years ago

    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))