Display data value from a non-active relation

[medlalami]

Hello,

I have 2 tables joined by a non-active relation:

 I would like to display some fields from tbl_workOrders and the IncidentNumber field from tbl_incidents but I can't do that manually because of the non-active relation.

What can you suggest?

[Ashish_Mathur]

If you want me to help you further, share the download link of the PBI file and show the expected result clearly.

[Ashish_Mathur]

Hi,

Why is the relationship not an active one?  If i does need to remain inactive, then you will have to write a measure with the USERELATIONSHIP() function.

[medlalami]

Indeed, I have another relation active with the calendar table. Userelationship function must be used with the calculate function but I just need to display the incidentNumber related to the workorderid.