Forum Discussion

hans263's avatar
hans263
New Member
4 years ago
Solved

Highest score based on 2 variables

Hi experts, I have an issue regarding a table with staffmembers, training they followed and the scores given for each training. Table looks like this: The result should be that for each depar...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi hans263 
    Please refer to attached sample file with the solution

    Count of Highest Scores = 
VAR CurrentScore = SELECTEDVALUE ( 'Table'[TrainingTypescore] )
RETURN
    COUNTROWS (
        FILTER (
            VALUES ( 'Table'[Staffmember] ),
            CALCULATE ( MAX ( 'Table'[TrainingTypescore] ), ALL ('Table'[NameTrainingFollowed], 'Table'[TrainingTypescore] ) )
                = CurrentScore
        )
    ) + 0
hans263's avatar
hans263
New Member
4 years ago

Yep. This works great! Many thx.