Course Attendence

[Anonymous]

I need to create a table that shows who and who has not attended a course.

I have two tables:

1. Employee Table

2. Course Table

Goal:

Does anyone know of a good way to tackle this?

[Anonymous · Accepted solution]

Hi @Anonymous ,

Here's the raw data i used and you can refer to the following steps.

1# Create relationship between these two tables.

2# Create measure as below.

Measure = IF(SELECTEDVALUE('Table'[emply id])=SELECTEDVALUE('Table (2)'[emply id]),"yes","no")

3# Create a visual as below.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38]

Hi @Anonymous 

just be sure you've got a relationship between tables by field emply_id and pick all columns starting from Employee Table[emply_id] to table visual

[Anonymous]

So that will give me all employees associated with a course (ie they attended) but I also want to display employees who have not attended.

[az38]

@Anonymous 

set Active parameters "Show items with no data" for Employee Table[emply_id] column