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
    5 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. 

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?
suvechha's avatar
suvechha
Helper IV
5 years ago

Hi Alison ,

 

Your suggestion Option 1 work.

But I want the Option2 to work.

 

I followed every steps you mentioned,

 

Please can you have a look on the sample file and let me know what is wrong.

https://1drv.ms/u/s!AhqwbtIVEKQ2bBzZ7PyqQ6ot-vk?e=coQGzS

 

You steps helped me to acheive almost what I want but not working 100%.

 

Thanks

Suvechha

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    5 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
      5 years ago

      Thanks Allison for your help.