Forum Discussion

lopezbec's avatar
lopezbec
Advocate I
4 years ago
Solved

DAX Help with Lookup for multiple users

I have a Sharepoint list that I am creating a PBI report for.  This sharepoint list will have one or more IDs for an approval workflow. I want to show who the Approval request went to using the Appr...
  • lopezbec's avatar
    lopezbec
    4 years ago

    Thanks for your assistance, but I found a different solution.  AssignedTo is also found under FieldValuesAsText.  I selected the fields I needed and it is already available.  No function needed.

     

     

lopezbec's avatar
lopezbec
Advocate I
4 years ago

ValtteriN 

 

I am new to PowerBI.  I use the user table for both the ApproverSentToId as well as the FinalApproverID to get the names for the report.  For the ApproverSentToID there could be 1 to many.  The FinalApproverID has only one user.  I am not sure what you mean by using the "passive + USERELATIONSHIP)".  

ValtteriN's avatar
ValtteriN
Community Champion
4 years ago

Hi,

I meant that if you can't have an active relationship (like the one in my example) between the tables. You can create an inactive relationship and use USERELATIONSHIP function within CALCULATE to activate the relationship and combined this with variables to get the values you desire. However, I would recommend first trying to create an active relationship.

  • lopezbec's avatar
    lopezbec
    Advocate I
    4 years ago

    @ValtteriN 

     

    I have created an active relationship, but I do not understand how what you have above works, my ApprovalSentToID column will have 1 to many ids separated by commas.  I do not know if there will be one or 10 approver IDs in that field.  Can you provide the measure text of what you used?