Forum Discussion
TBensen
Helper I
Helper IAdding 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/Deskt...
TBensen I think you want to see the data by location (both people and incidents), for which you can create a location table and set it up like the seniority years table (connected to both tables). You can do this with SUMMARIZE to combine and de-dup the locations from both tables.
Locations = DISTINCT(UNION(SUMMARIZE(Employee,Employee[Location]),SUMMARIZE(Incident,Incident[Location])))Then join like you did seniority years.Does that answer your question?
