Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
If you want me to help you further, share the download link of the PBI file and show the expected result clearly.
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.
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |