Forum Discussion

zeckert's avatar
zeckert
Helper I
9 years ago
Solved

Need to sum based on unique values

I have a Purchase order report that i need to be able to group by vendor but there is multiple rows for one PO due to line items.  There is a column that has the final amount but I keep getting it co...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    zeckert

     

    Hi,

     

    Try with this Measure:

     

    TotalOrderAmount = SUMX(DISTINCT(Table1[PO#]),CALCULATE(AVERAGE(Table1[Order Amount])))

     

    Regars

     

    Victor

    Lima - Peru

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

zeckert

 

Hi,

 

Try with this Measure:

 

TotalOrderAmount = SUMX(DISTINCT(Table1[PO#]),CALCULATE(AVERAGE(Table1[Order Amount])))

 

Regars

 

Victor

Lima - Peru

Anonymous's avatar
Anonymous
Not applicable
5 years ago

This worked but still dont understand why we need to use AVERAGE instead of SUM.