Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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,
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.
@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.
Question edited. Tried to explain in details.
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.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |