Forum Discussion

Junaid11's avatar
Junaid11
Helper V
3 years ago
Solved

Summarize not showing correct total

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 t...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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]
    )

amitchandak's avatar
amitchandak
Super User
3 years ago

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]
)