Forum Discussion

johnf's avatar
johnf
Helper I
8 years ago
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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    OK, try this:

     

    Measure = SUMX(SUMMARIZE(DistinctSum,[KEY],"Payment",AVERAGE(DistinctSum[PAYMENT])),[Payment])
johnf's avatar
johnf
Helper I
8 years ago

Greg_Deckler

 

I think this is because when passing the DISTINCT there's no condition applied to provide a boolean value for FILTER to use.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

OK, try this:

 

Measure = SUMX(SUMMARIZE(DistinctSum,[KEY],"Payment",AVERAGE(DistinctSum[PAYMENT])),[Payment])