Forum Discussion
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 in the fact table. I have an additional date table for filtering (DimDate goes has more historical data than what needs to be displayed in slicers), which is the extra relationship in the model
The standard measure results like so:
Adding USERELATIONSHIP, in this example, renders the same:
I've trived many permuatations on the measure (latest attempt from here Solved: Help needed with AVERAGEX and USERELATIONSHIP - da... - Microsoft Fabric Community) and have seen different behavior from the dates being shown, but never an update on the measure column.
Any assistance would be greatly appreciated.
Actual problem was column definition for one for the other date fields. Setting that to Date instead of text fixed the reports.
3 Replies
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:
Actual problem was column definition for one for the other date fields. Setting that to Date instead of text fixed the reports.
