Forum Discussion
Helper ICreate a Counted Summary Table
Hi TBensen ,
You can do this by introducing a "Seniority" table with each of the numbers for each row. Then removing any other relationships between the Employee table and Incident table, join them both to the Seniority table on the number of years columns.
You can then create a measure for Incidents, People, and Rate of Incidents.
Incidents = countrows(Incident)+0
People = COUNTROWS(Employee)+0Rate of Incidents = DIVIDE([Incidents],[People])Then you create a table with the Seniority table's Seniority Year and the measures you want.
Microsoft EmployeeHi TBensen ,
You can do this by introducing a "Seniority" table with each of the numbers for each row. Then removing any other relationships between the Employee table and Incident table, join them both to the Seniority table on the number of years columns.
You can then create a measure for Incidents, People, and Rate of Incidents.
Helper IHello,
This worked out great! Thank you for your help. I was definitely over-complicating what I was trying to accomplish.
Thanks Again,
Trevor Bensen