Forum Discussion
Filter Related Table using inactive relationship
After some playing around, the solution that I found was to add a calculated column in the FundDD table which serves as a flag to denote if that row is a department or not. I did this by doing a lookup on the Fund Code. This yielded the following table:
Fund Name Fund Code Department Abbr isDepartment Fund 1 FF001 FN 0 Fund 2 FF002 FN 0 Finance AA002 FN 1
By doing so, I was able to add the "isDepartment" column as a filter on visuals and by doing so, I was able to use the 1-many relationship and forgoe the 1-1 entirely.
After some playing around, the solution that I found was to add a calculated column in the FundDD table which serves as a flag to denote if that row is a department or not. I did this by doing a lookup on the Fund Code. This yielded the following table:
| Fund Name | Fund Code | Department Abbr | isDepartment |
| Fund 1 | FF001 | FN | 0 |
| Fund 2 | FF002 | FN | 0 |
| Finance | AA002 | FN | 1 |
By doing so, I was able to add the "isDepartment" column as a filter on visuals and by doing so, I was able to use the 1-many relationship and forgoe the 1-1 entirely.