Forum Discussion

walkery's avatar
walkery
Icon for Helper I rankHelper I
8 years ago
Solved

Sum column based on unique IDs

Hi: I have a dataset with 50K records in it. Some of those records have duplicate IDs, leaving only 47K unique values, they just have a different employee attached to them thus resulting in a duplica...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    You probably want to do something like:

     

    Measure = SUMX(SUMMARIZE(Table,[Deal ID],"__Revenue",AVERAGE([Revenue])),[__Revenue])
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

You probably want to do something like:

 

Measure = SUMX(SUMMARIZE(Table,[Deal ID],"__Revenue",AVERAGE([Revenue])),[__Revenue])
  • walkery's avatar
    walkery
    Icon for Helper I rankHelper I
    8 years ago

    Thanks!