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

     

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

Anonymous

 

With USERELATIONSHIP in a Dax Measure you can activate relationship between the tables (The active and Inactive)

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
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 :)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Vvelarde 

    If i want to use two more relation ships with the userealtionship function can it be possibel 

     

    Calculate(count(inc),userelationship(inc[country],user[country]),userelationship(inc[user],user[user])

     

    Thanks in advance