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])
Hello,
How can you sum two values from two different tables? I have tried to use it as a measure but the thing is that it duplicates the rows.
How can you sum two values from two different tables? I have tried to use it as a measure but the thing is that it duplicates the rows.