Adding a Common column from two tables into a created table that is shared between the two table

Hello (@DataZoe),

Hopefully the subject makes sense and this issue is stemming from a previous post I had about creating a counted summary table found here: https://community.powerbi.com/t5/Desktop/Create-a-Counted-Summary-Table/m-p/1637315#M657872

The answer to this post had me create a table that used a column called Seniority years that was found in my two tables, Employees and Incidents.  I created a relationship between the 3 tables by using the created Seniority Table and this allowed me to generate a Rate of Incidents based off of the seniority year number.

Here are the tables that exist.

Incidents Table:

With this table, I can get a count of incidents by Seniority:

Employee Table:

With this table I get a count of the organization population based off of the Seniority years.

With the help of DataZoe , I created the relational tables like this:

Using these tables I created a grouping on the Seniority Years column and I want to be able to use a slicer across all visualizations to show the breakdown of the Rate of Incident per location.

If a user selects Location_1, we should see the count of incidents for all of Location_1 and the population of people at Location_1, which should give us a Rate of Incident by Seniority group per Location Population.  Currently if I add a location slicer, and 1 location is selected, I get a count of incidents per location / total population per seniority groupings.

I think I need to add these locations to the Seniority table like what is shown below, but I'm not sure what the best way to go about this is.

I think once I have a table that looks like this I should be able to add a slicer to the report that allows me to select a location and see the data represented based on that Location selection.

Thanks,

Trevor Bensen