Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Creating relationships to multiple columns and displaying data

I have imported a SharePoint list IncidentTracker. The "Created By" and "Modified By" columns are displayed as "CreatedByID" and "ModifiedByID" respectively.   I also imported UserInformationList f...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

     

     

    CreatedByUser = CALCULATE(VALUES(User[Name]),USERELATIONSHIP(Incident[Createdby],User[User]))

    ModifiedByUser = CALCULATE(VALUES(User[Name]),USERELATIONSHIP(Incident[Modifiedby],User[User]))

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Vvelarde

 

I tried using the method you mentioned. But I get this error: USERELATIONSHIP function can only use the two columns references participating in relationship

 

CreatedByM = CALCULATE(VALUES(UserInformationList[WorkEmail]),USERELATIONSHIP(IncidentTracker[CreatedById],UserInformationList[Id]))

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

Your relationship look lie this;?

 

Created and Modified related to User column in user table 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Ok. I got it now! Thanks Vvelarde :)

    • praveenasoni's avatar
      praveenasoni
      Regular Visitor
      6 years ago

      Hello I am also facing this error. I am really new to powerBI. Can you please help me with this error.

      • joepbreslin's avatar
        joepbreslin
        Regular Visitor
        6 years ago

        Finally found the solution from this page. Had to use FIRSTNONBLANK instead of VALUES. Otherwise, what was described in this thread worked for me 🙂