Forum Discussion
WetGruul
2 years agoRegular Visitor
Training Programs & Enrollment Data
I am looking for support in relating two datasets to understand the following about the people in our firm: (1) for each of our available training programs, how many people have attended (2) how many...
Ashish_Mathur
2 years agoSuper User
Hi,
Create a Program slicer and select a talent entry there. For question1 (those who did not attend), try these measures
Attended = distinctcount('Table2'[User ID])
Not attended = countrows(filter(values('Table1'[User ID]),[attended]=blank()))
Hope this helps.