SUMX and Summarize

[macwhe]

Hi All,

I am trying to use SUMX with Summarize however my result is not correct .Below it is a example of the data.

The expected result is to have amount =500 on line 4 , however my measure gives me 1000 as result.

MY Measure=Calculate(SUMX(SuMMARIZE(Table, Facture,Prod ID,Amount),SUM(Amount), Filter (table(And(MAX Prod ID= PROD ID, MAX(Lineid))))

Many Thanks in advance

MAX Prod ID	Facture	Amount	Prod ID	Line ID
14	INV1	200	1	1
14	INV1	300	2	2
14	INV1	500	14	3
14	INV1	500	14	4

[Tahreem24 · Accepted solution]

@macwhe ,

First create one Calculated column to make Max of Line ID like below:

Max LineID =  IF(MAX('Table'[Line ID])='Table'[Line ID],1,0)
Then create your final measure to get the expected result:

Final Measure = CALCULATE(SUM('Table'[Amount]),FILTER('Table',AND(('Table'[Prod ID]='Table'[MAX Prod ID]),'Table'[Max LineID]=1)))