Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@chris886
I guess you are using live connection mode so you can only create a measure for this.
@chris886
I guess you are using live connection mode so you can only create a measure for this.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |