Forum Discussion
Helper IIIRLS/Dynamic Filter Help needed
You don't have the two table connected together do you? There is no need for a relationship between the two tables. That is the only thing I can think of that might cause the problem.
Super UserIf you are trying to apply filters to multiple tables you would have to write rule for each one in your Role. If there was a Table3 in the example below and you wanted to apply a filter to it as well you would have to select table3 and put the DAX filter code in. You can't filter Table3 with code that is applied to Table2.
Helper IIIjdbuchanan71
There is only 2 tables
the part about adding other columns means from either of the 2 tables in the expression.
Dont know if you got to see this post
POST
Sorry will try to better explain my objective
When a user 'Peter Green' logs in I would like him to only see from SA table
Anyone who is at the same [location] and [job_watch]
Sorry I have a much clearer head today!
Expected outcome
| full_name | email_address | location | job_watch | role_basic | assessment |
| Mike New | [email protected] | B | green | FF | 78 |
| Pete Green | [email protected] | B | green | FF | 76 |
When a user 'Andy Jones' logs in I would like him to only see from SA table
| full_name | email_address | location | job_watch | role_basic | assessment |
| Andy Jones | [email protected] | A | red | Crew | 90 |
| Mike White | [email protected] | A | red | FF | 69 |
SA Table
| full_name | email_address | location | job_watch | role_basic | assessment |
| Andy Jones | [email protected] | A | red | Crew | 90 |
| Paul Smith | [email protected] | B | white | Watch | 79 |
| Dave Brown | [email protected] | C | white | Crew | 89 |
| Rich Davis | [email protected] | D | blue | Crew | 76 |
| Steve Blue | [email protected] | D | blue | FF | 80 |
| Mike New | [email protected] | B | green | FF | 78 |
| Pete Green | [email protected] | B | green | FF | 76 |
| Mike White | [email protected] | A | red | FF | 69 |
| Peter Long | [email protected] | B | blue | FF | 69 |
| Mitchell Bow | [email protected] | B | red | FF | 69 |
WMFSED table
| NAME | WORK_EMAIL | JOB_LOCATION | JOB_WATCH | Role_Basic |
| Andy Jones | [email protected] | A | red | Crew |
| Paul Smith | [email protected] | B | white | Watch |
| Dave Brown | [email protected] | C | white | Crew |
| Rich Davis | [email protected] | D | blue | Crew |
| Steve Blue | [email protected] | D | blue | FF |
| Mike New | [email protected] | B | green | FF |
| Pete Green | [email protected] | B | green | FF |
| Mike White | [email protected] | A | red | FF |
| Peter Long | [email protected] | B | blue | FF |
| Mitchell Bow | [email protected] | B | red | FF |