Forum Discussion

suvechha's avatar
suvechha
Helper IV
6 years ago
Solved

Need Suggestion

Hi there , I have a query like below and I am struggling to get the "ti"."FIRST_NAME" AS "Technician" in my power bi app , Please kindly assist me , as I am new to power BI - it would be good if ...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    6 years ago

    suvechha
    You need to define the entire path of relationships and it seems that RELATED() function does not like the USERELATIONSHIP, so I have fixed it. Please check if this returns the expected results for technician:

    Technician = CALCULATE(SELECTEDVALUE(AaaUser[FIRST_NAME]), USERELATIONSHIP(WorkOrder[WORKORDERID],WorkOrderStates[WORKORDERID]), USERELATIONSHIP(WorkOrderStates[OWNERID], SDUser[USERID]), USERELATIONSHIP(SDUser[USERID], AaaUser[USER_ID]))

     

    UPDATE: suvechha if you are getting an error about single path, you will need to make the relationship between WorkOrder and WorkOrderStates a many to one relationship with single cross filter direction. 

suvechha's avatar
suvechha
Helper IV
6 years ago

Hi Allison,

 

I took the option 2.

But I am getting an error message

The column 'AaaUser[FIRST_NAME]' either doesn't exist or doesn't have a relationship to any table available in the current context.

 

Please kindly assist.

AllisonKennedy's avatar
AllisonKennedy
Community Champion
6 years ago
You can upload the sample file to OneDrive and share the link.

Are you getting the error message on Requester or Technician or both?

Do all the arrows in the relationships you created make a cascading connection from AaaUser to WorkOrder with all the arrows pointing toward WorkOrder table?