Create Pivot and DAX measure to link columns and measures in 2 tables

[anands06]

Dear experts and friends, I need help with below, if you can advise what is the best approach to link the tables / measure. Idea is to leverage the measure already created in table 1 and use a common shipment ID as a link.

Goal - To link measure (fx) of Events_Table1 with measure (fx) of Count_Invoice_ID in Invoice table2

Issue - Unable to link the measures of the tables and unable link measure in table 1 with invoice table 2 columns

Help needed _ Please find below details, hope I am able to explain what is needed by using below data model and table details.

Let me know if you need more information. Regards

Events_Table1	Invoice_Table2	Comments
Unique Shipment_ID (Primary Key)	Shipment_ID	Duplicate Shipment_ID in table2
Origin	Unique Invoice_ID	Multiple Invoice ID for same Shipment_ID
Destination	Origin
Truck Arrival time stamp	Destination
Truck Depart time stamp	Truck Arrival time stamp
Measure(fx)-Count_of Truck arrival time stamp	Truck Depart time stamp
Measure (fx)-Count_ Truck Depart time stamp	Measure (fx)- Count_Invoice_ID

[some_bih]

Hi @anands06 from picture I see your table are connected via inactive relationship.

To get measure working for this scenario in DAX you need your measure to use function USERELATIONSHIP, pattern  as below

UsingUseRel=
CALCULATE (
[<your measure],
USERELATIONSHIP ( Table1[ColumnNameX], Table1[ColumnNameX]] )
)

Did I answer your question? Mark my post as a solution! Kudos Appreciated!