Finding data that does not match

[cookieka]

I have a set of organisations and a set of training courses they can complete.  I have 20 courses that they can choose from.  My data records their organisation name and the training they've carried out (dates, names etc).  

There is a particular course they are all supposed to do and I want to narrow down which organisations have not done it.  Is there a simple approach to this?

[amitchandak · Accepted solution]

@cookieka , Create measure who has done the course

M1= countrows(filter( Table, Table[Course] in {"Course1"} ) )

Count of org not have done this plot with the organization if needed

M2= countx(values(Table[Organization]), if (isblank([M1]) ,[Organization], blank()) )

[cookieka]

Thank you - that worked an absolute treat!