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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

zeckert ,

Do you get expected result when directly creating table visuals as follows? If not, please post you desired result.



Regards,
Lydia