How to check if a column in 1 table matches with a column in another table

[azlocal21]

Hello there,

I'm trying to create a dashboard for attendance of weekly learning sessions. I want to call out individuals who have not attended the session selected.

I have two tables:

1. 'Master' - A master roster

Name

Person1

Person2

Person3

Person4

Person5

2. 'AllSessions' - Running list of all session attendance reports

Name	SessionTitle
Person1	SessionA
Person2	SessionA
Person4	SessionA
Person1	SessionB
Person2	SessionB
Person3	SessionB
Person4	SessionB
Person1	SessionC
Person2	SessionC
Person3	SessionC
Person4	SessionC

Both have a common column of [Name]. I would like to check if Master[Name] = AllSessions[Name].

There will be multiple matches (ideally the individuals are attending every unique session). I'm hoping to add slicers to the dashboard that would allow someone to isolate the AllSessions[SessionTitle] column to a particular session giving us a list of crew who did not attend that session. If possible, it would be nice to do add a count of how many unique sessions have occurred and a count of how many unique sessions an individual has attended.

Using the sample data this is sort of what I'm looking for as the end result:
If a SessionTitle Slicer set to: SessionB

Crew who missed session: Person5

SessionTitle distinct count: 1

or

If a SessionTitle Slicer is set to: All

Crew who missed session: Person5 (missed 3 sessions), Person3 (missed 1 session)

SessionTitle disctint count: 3

I've tried Measures and Custom Columns and looked at different articles but was not finding anything that made sense to me.

Any help is greatly appreciated! 

[danextian · Accepted solution]

Hi @azlocal21 ,

You'll have to create another table that has all the possible combinations of Name and Session and use that instead. Please try this pbix.