Security Filter based on reference List

[Ismail_Ostrilsk]

Hello there, 

I have been trying to find a solution to filter a table based on a referenced list containing user info. 

My Course Table, contains a ref table "Course Contents" that allows me to add a list of Learners to a Course entry, I am attempting to filter the table via security filter to only display courses where the Learner has been added on.

Learners (List) in Course Table:

Course Contents i.e. Learners refrenced Learners in Courses

Current User Slicer from Learners Table

My attempts so far have been quite unsuccessful, the ultimate goal is to show only courses where the Learner i.e. current user is in the associated Course Contents (Learners List)

Attempt 1: 

Attempt 2: 

Any help would be most welcomed. 

Thanks, 

Ismail

[Marc_Dillon]

IN( ANY( Current_User[Learner_ID] ) , [Learners][Learner_ID] )

[Ismail_Ostrilsk]

Hey Marc, 

Thanks for the quick response. It makes sense but its bringing back an error. 

[Marc_Dillon · Accepted solution]

Oh duh, that makes sense, you can't calculated the VC on a table before evaluating its security filters. But also, what a weird error message, why is it referring to _rownumber?

Here's another option:

IN(  [key-column] , SELECT( courseContents[course-id[] , in( [learner-id] , currentUser[learner-id] ) ) )

[Ismail_Ostrilsk]

Worked a charm! Thanks Marc 🙂