UserRelationship Dax measure error

Question

Hi Expert&nbsp;Cannot see my error here with the following dax MeasureFire &amp; Life (Emergency) Due = &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE([Count], &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; USERELATIONSHIP(USVF_WO_22_12_22[TARGSTARTDATE],DimDate[Date])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,FILTER('USVF_WO_22_12_22','USVF_WO_22_12_22'[WORKTYPE] = "RW"))+0&nbsp;Modelwhen i make the relationship active between dimdate and Targetstartdate - i get the correct result 1885, when i use usersrelation via the inactive route i get 1145....

v-xiaotang · Accepted Answer

Hi&nbsp;Anonymous&nbsp;
Thanks for reaching out to us.
Here is a tutorial about how to use USERELATIONSHIP to Activate an Inactive Relationship for your reference,
Power Pivot Principles: Using USERELATIONSHIP to Activate an Inactive Relationship &lt; Blog | SumProduct are experts in Excel Training: Financial Modelling, Strategic Data Modelling, Model Auditing, Planning &amp; Strategy, Training Courses, Tips &amp; Online Knowledgebase
&nbsp;
&nbsp;
Best Regards,
Community Support Team _Tang
If this post&nbsp;helps, please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

UserRelationship Dax measure error

1 Reply

Related content

USERRELATIONSHIP

Userrelationship y fecha

USERRELATIONSHIP gives wrong results

Multiple USERRELATIONSHIP. Possible?

Error: The model doesn't have a measure named Measure on table