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
Solved! Go to 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] ) ) )
IN( ANY( Current_User[Learner_ID] ) , [Learners][Learner_ID] )
Hey Marc,
Thanks for the quick response. It makes sense but its bringing back an error.
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] ) ) )
Worked a charm! Thanks Marc ๐
User | Count |
---|---|
26 | |
25 | |
25 | |
22 | |
22 |