Summarize not showing correct total

[Junaid11]

Hello,
I have duplicate values  and I wanted to sum only distinct values so I used the below formual which was showing correct results if shown based on the week values but as total it shows wrong total as shown in picture.
It would be quite helpful if I can get the correct total along with the same values against week which are correct.
Thank you

Sample =

SUMX (

    SUMMARIZE ('Remedial Tracker','Remedial Tracker'[NO.] , 'Remedial Tracker'[RS Attended] ),

    'Remedial Tracker'[RS Attended]

)

[amitchandak · Accepted solution]

@Junaid11 , it should be like

Sample =
SUMX (
SUMMARIZE ('Remedial Tracker','Remedial Tracker'[NO.] ,'Remedial Tracker'[week] , 'Remedial Tracker'[RS Attended] ),
'Remedial Tracker'[RS Attended]
)

or

Sample =
SUMX (
SUMMARIZE ('Remedial Tracker','Remedial Tracker'[week] , 'Remedial Tracker'[RS Attended] ),
'Remedial Tracker'[RS Attended]
)