How I can calculate sum values if me need this sum for unique from another field with filter

[Anonymous]

Hi everyone! how I can sum PRODSERIE without dublication(for SERIE). Me need get result:  SERIE-1(100) + SERIE-2(300)+SERIE-3(300)=700 for Type=0 and SERIE-4(300)=300 for Type 1;

ID	SERIE	PRODSERIE	TYPE	ANOTHER VALUE
1	1	100	0	1
2	1	100	0	50
3	2	300	0	23
4	2	300	0	254
5	2	300	0	234523
6	3	300	0	400
7	4	300	1	1545
8	4	300	1	345345

[amitchandak · Accepted solution]

Try like

sumx(summarize(table,table[SERIE], "_1",maxX(filter(Table, (Table[TYPE]=0 && table[SERIE]<=3) ||
(Table[TYPE]=1 && table[SERIE]=4)) Table[PRODSERIE])),[_1])

[Greg_Deckler]

Try using SUMMARIZE like:

Measure =

  SUMX(

    SUMMARIZE('Table',[SERIE],"__Value",AVERAGE([PRODSERIE])),

    [__Value]

  )