Forum Discussion
Display data value from a non-active relation
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?
3 Replies
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.
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.
If you want me to help you further, share the download link of the PBI file and show the expected result clearly.
