Correct totals for measures

[Anonymous]

I am building a "report card" for employees taking courses. The data consists of "course name, launch number(attempts to pass course), score(earned by employee), points(total points per course), and employee name. I am having trouble with getting the correct total of the measure created for score. The table below shows the course, total score, # of attempts. For mulitple attempts the total score is adding up the scores of all the attempts and not just the highest score taken. 

Sum of Score is self explanatory and FORMAT is whole number and summarization is SUM.

(You can see that "EmployeeeHighScore" takes the highest but does not add them up for a total which I need for the report card.)

How can I get the measure EmployeeHighScore to total the correct way.

DAX for Employee High Score is : 

MaxScoreperLearner = CALCULATE(MAX('ICT Report Data'[Score]), FILTER('ICT Report Data', 'ICT Report Data'[Score] = MAXX(FILTER('ICT Report Data', 'ICT Report Data'[Learner Id] = EARLIER('ICT Report Data'[Learner Id])), 'ICT Report Data'[Score])))

[rajendraongole1 · Accepted solution]

Hi @Anonymous - you can create one more measure to sum these highest scores for the total score.

Measure:

TotalMaxScore =

SUMX(

    SUMMARIZE(

        'TotalsV',

        'TotalsV'[Employee Name],

        'TotalsV'[Course Name],

        "MaxScore", [MaxScorePerCourse]

    ),

    [MaxScore]

)

Snap:

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!