Forum Discussion

zeckert's avatar
zeckert
Icon for Helper I rankHelper 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

mattbrice's avatar
mattbrice
Icon for Solution Sage rankSolution Sage
9 years ago

If your image is a "before" pic, can you include an "after" (or what you want your sample data to look like)?