Forum Discussion
Data Modeling with Timesheets (Data Ambiguity Relationship Issue)
Managed to resolve this using an example from another thread. The issue was that some of my fact tables had other relationships, removing other joins and rebuilding my relationships resolved the issue and I was able to create the relationships based on my example.
For reference, "WorkingHours" needs to be a calculated metric in case anyone else is in need of this, otherwise you just get the number of working hours based on the filters applied, this filter would only apply to time not staff member and/or number of staff selected - you can multiply this up with something like as follows:
WorkingHours = (SUM(DateDim[isWorkingDay])*7.5)*COUNTA(Employees[Full Name])
Managed to resolve this using an example from another thread. The issue was that some of my fact tables had other relationships, removing other joins and rebuilding my relationships resolved the issue and I was able to create the relationships based on my example.
For reference, "WorkingHours" needs to be a calculated metric in case anyone else is in need of this, otherwise you just get the number of working hours based on the filters applied, this filter would only apply to time not staff member and/or number of staff selected - you can multiply this up with something like as follows:
WorkingHours = (SUM(DateDim[isWorkingDay])*7.5)*COUNTA(Employees[Full Name])