Forum Discussion
Solved
Remove duplicated rows in SUM calculation
Hello, I'm having some issues in trying to work out how to remove duplicate rows from a calculation. I have the following dataset (highly simplified from actual) KEY NAME JOB PAYMEN...
OK, try this:
Measure = SUMX(SUMMARIZE(DistinctSum,[KEY],"Payment",AVERAGE(DistinctSum[PAYMENT])),[Payment])
Hi Zubair_Muhammad and Greg_Deckler
I have a similar issue with two columns "Engagement" and "Size" - tried the below formula but it gave an error "The expression refers to multiple columns. Multiple columns can not be converted to a scalar value".
- Under the "Engagement" column, I have values as "Name A","Name B","Name A","Name B", "Name C","Name C","Name D","Name A","Name B","Name A" etc...
- Under the "Size" column, I have values as "10","20","40","30","50","70","60","10","50","40"
1 Enrollment = SUMMARIZE('Demographic Information','Demographic Information'[Engagement], "Participants", AVERAGE('Demographic Information'[Size]))