Table Relationship Query

It seems like you're trying to create a visual that displays a staff list with required training based on their position and also indicates whether that training has taken place. It's essential to ensure that your data model and relationships are correctly set up to achieve this. Based on your description, you can use a combination of tables, slicers, and matrix visuals. Here are the steps to achieve this:

1. **Data Model Setup**:
Ensure that you have the following tables in your data model:
- Staff table with information about employees and their positions.
- Training table with information about training courses and related fields.
- A bridge table that connects employees to training courses, indicating which employees have taken which courses.

Ensure that the relationships between these tables are correctly established. The relationship between the Staff table and the Training table should be through the bridge table.

2. **Create a Matrix Visual**:
Create a matrix visual with the following fields:
- Rows: Employee Name from the Staff table.
- Columns: Training Name from the Training table.
- Values: Count of Training (use the bridge table) to show how many times a training course has been taken by each employee.

3. **Filter Training Requirements**:
To display required training based on positions, add a slicer visual to your report. This slicer should allow you to select positions, which will filter the matrix visual. This way, you can see which training courses are required for employees in the selected positions.

4. **Highlight Missing Training**:
You can use conditional formatting to highlight missing training. For example, you can format cells where the Count of Training is zero with a specific background color to indicate missing training.

5. **Use Drill-Through or Tooltip**:
You can set up a drill-through feature or tooltips in the matrix visual to view more details about the training courses or the specific employees' training records.

This approach allows you to view staff lists, identify required training based on positions, and see whether the training has taken place. If adding fields from the Training table is causing issues with your visualization, ensure that the relationships between your tables are set correctly, and the filtering is configured appropriately. Additionally, make sure that the Training table fields do not interfere with the employee position requirements.