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])
MilanAXVII's avatar
MilanAXVII
Helper I
8 years ago

HI,

 

I tried to make your stuff, but i dont know why, it's did the average of the whole column.

 i have in the first table some times but some are for the same merged cells. In the second column i did the sum betwin cells which have the same indicator (merged) so in the list there is for example

12    12   Q125

15    27    Q158

14    14    Q789

12    27   Q158

14    14   Q963

 

And I need to have just

12    12   Q125

15    27    Q158

14    14    Q789

14    14   Q963

 

New Table = 
SUMMARIZE (
    Table_owssvr4;
    Table_owssvr4[Merged.1];
    "total fg "; AVERAGE ( 'Table 4'[total tempo FG])
)

Can you help me?