Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Course Attendence

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
6 years ago
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.

4 Replies

az38
Community Champion
6 years ago
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
  Not applicable
  6 years ago
  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
    Community Champion
    6 years ago
    Anonymous
    
    set Active parameters "Show items with no data" for Employee Table[emply_id] column
Anonymous
Not applicable
6 years ago
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.

Related content