Forum Discussion
clarkey1988
Helper II
Helper IICalculate Measure - Distinct Count Average Number of Drivers Each Week
Hi, I wonder if anyone can help. I have a table called "Pay Detail" and I want to create a measure that shows the average number of drivers we paid each week over the year. However, I have filters by...
That's correct. You have to create relationships between the calculated table and the dimension tables. This isn't necessary in the alternate approach I mentioned, where you eliminate the intermediary calculated table and create a relationship between the date table and 'Pay Detail' table.
DataInsights
Super User
Super User
That's correct. You have to create relationships between the calculated table and the dimension tables. This isn't necessary in the alternate approach I mentioned, where you eliminate the intermediary calculated table and create a relationship between the date table and 'Pay Detail' table.
clarkey1988Helper II
Helper III used your work around method and it worked perfect. Thank you so much!