Forum Discussion
Sum by distinct ID from duplicated rows
I have a non aggregated table that is transactional based on event that has duplicated ID's and Amounts similar to column a/b and I would like to have a measure to apply in my visualizations that sho...
Hello Anonymous
Give this a try, you will just have to change the name of your table in the measure.
Measure = VAR XTable = SUMMARIZE(Table1,Table1[Vendor],Table1[Order ID]) RETURN SUMX(XTable,MAX(Table1[Amount]))
jdbuchanan71
Super User
Super UserHello Anonymous
Give this a try, you will just have to change the name of your table in the measure.
Measure = VAR XTable = SUMMARIZE(Table1,Table1[Vendor],Table1[Order ID]) RETURN SUMX(XTable,MAX(Table1[Amount]))
Thank you jdbuchanan71 for the quick reply, this gave me exactly what I was looking for.