Forum Discussion
Finding data that does not match
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?
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()) )
2 Replies
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()) )
Thank you - that worked an absolute treat!
