Forum Discussion
Helper IIICalculating Event duration Hours by Resource and Date
wkeicher issue is with resource table on many side. Either change the cross filter direction of relationship to both or write a measure use CROSSFILTER function in it.
wkeicher - At issue here is that the Date table is not related to the fact table, so the calculation is counting all dates in the date table. As a best practice, you generally want to make relationships from your date dimension table to each fact table.
Hope this helps,
Nathan
Super Userwkeicher can you share tables relationship diagram and also what you are using in matrix for rows, columns, and value.
wkeicherI highligted the Joined fields.
- wkeicher
Rows = The Resource Name
Coumns = Dates
Hours = Hours assigned to the event
Ideally - Once I get the correct hours, I will want to measure the hours per resouce/Hours in a work day to get Utilization %.
- parry2k
wkeicher issue is with resource table on many side. Either change the cross filter direction of relationship to both or write a measure use CROSSFILTER function in it.