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

    Thanks Allison for your help.