Forum Discussion
Helper IIICalculating Event duration Hours by Resource and Date
I have a Table of events. Each Event has a date & duration( in hours). Each Event has a resource assigned through a relationship with an assignment table. . I am trying to build a visual of hours by resource and date.
My result is the same value for each resource by date. Also the date field (by way of Hierarchy) only shows the Number not the actual 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
