Forum Discussion
wkeicher
Helper III
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 ...
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
when its a repeating value like that it more often than not a relationship problem where the filters are not flowing as you would expect. Any chance you could share the pbix file?