Forum Discussion
Solved
Measure with Date Table and USERELATIONSHIP not working
I'm trying to get a measure for average time to completion, but cannot get the relationship and calculations to work. I have a date table with inactive relationships, as there's several date fields i...
Actual problem was column definition for one for the other date fields. Setting that to Date instead of text fixed the reports.
eauerbachML , You should not join DimDateCompletedOn with Date Table. It should directly join with Work orders, if needed. And you need activate join between Work orders and Dim Date, not DImDate and DimDateCompletedOn
Refer
Thank you, amitchandak
I had the wrong reference for USERELATIONSHIP (from rebuilding the measure so many times). Here's what I had been using before and the result:
Here's what I get with the relationship you suggested: