Inactive Relationship to get the field Technician ?

[suvechha]

Hi there,

How to get the field "Technician" in my power bi report by using the inactive joining between "SDUser" and "AaaUser" as they are already join by 

 "SDUser" "sdu"
LEFT JOIN "AaaUser" "aau" ON "sdu"."USERID"="aau"."USER_ID" .

How to create an inactive relationship like below in the same model with the same table 

LEFT JOIN "SDUser" "td" ON "wos"."OWNERID"="td"."USERID"
LEFT JOIN "AaaUser" "ti" ON "td"."USERID"="ti"."USER_ID"

Attaching the sql code attaching as with image ?
And sample model attached.

Data Model screenshot added.

Thanks
Suvechha

[v-lionel-msft]

Hi @suvechha ,

Like this?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[suvechha]

Hi ,

I used this measure to get the SDUserID

SDUserId = CALCULATE(

MAXX(SDUser,SDUser[USERID]),

USERELATIONSHIP(WorkOrderStates[OWNERID], SDUser[USERID])

)

which is represent in my sql query below:

LEFT JOIN "SDUser" "td" ON "wos"."OWNERID"="td"."USERID"

How to represent this below relationship (below)? 

LEFT JOIN "AaaUser" "ti" ON "td"."USERID"="ti"."USER_ID"

and get the result : "ti".FIRST_NAME as "Technician"

Thanks,

[v-lionel-msft · Accepted solution]

Hi @suvechha ,

Or like this?
please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@suvechha ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Refer this fro use relation

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...
Appreciate your Kudos.

[suvechha]

Question edited. Tried to explain in details.

[Arul]

Hi @suvechha ,

Can you please elaborate your question more clear? So that I can help you swiftly.

Thanks,

-Arul

[pranit828]

Hi @suvechha 

The problem statement is not very clear.

This issue might be related to all inner joins you have on all the columns and the technician column is coming from last left join table.

Unless all the joins produce a non null record, technician is going to be NULL.