Distinct count based on second table

[chris886]

Newbie here.  I'm trying to figure out how to count the distinct number of people that have taken a training. I have two tables that would appear like below. Some people have been around a long time and taken the same training more than once. 

I need help figuring out "Distinct number of people who have taken training". For the data below I'd be looking for a return of three.

Name	Training Course
Chris	Training #1
Chris	Training #1
Chris	Training #1
Brad
John	Training #1
John	Training #1
Tony
Sam	Training #1

Has to be done in DAX as I don't have access to the dataset/power query.

Thank you.

[Anonymous · Accepted solution]

@chris886 

I guess you are using live connection mode so you can only create a measure for this. 

Measure = CALCULATE(DISTINCTCOUNT('Table'[Name]),FILTER('Table',[Training Course]<>BLANK()))

Paul Zheng _ Community SZhengt Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.