Counting if a Value occurs regardless of duplicates

[knightkblack]

I'm trying to calculate how often certain employees finish a training course. The only issue is that some of the employees are in the system as having completed it twice. There is a column in the data for when the employee completed certain achievements. So in the raw data, the employee is appearing multiple times for each of these achievements. The way that this course achievement is tracked, is there is a specific code, 'TRNTRN' entered into their profile that signifies if they completed the course. 

What I had done is created a column with a simple if statement that said if the employee had 'TRNTRN', put a 1 otherwise put a 0. But then when I get the list of employees the total is increased because of the duplicates.  As you can see below some employees have a 2 which then increase the overall count. There are only 101 employees that have completed the course not 108. 

In the end, I'm just looking to know if an employee has completed the course, regardless of how many times. Any help would be appreciated!

[v-chuncz-msft · Accepted solution]

@knightkblack,

You may add a measure as shown below.

Measure =
SUMX (
    SUMMARIZE ( Table1, Table1[Column1] ),
    CALCULATE ( MAX ( Table1[Column2] ) )
)