Forum Discussion
Solved
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 ...
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 , 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!
