Forum Discussion

Junaid11's avatar
Junaid11
Icon for Helper V rankHelper 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 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]
)


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

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper 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]
    )