Forum Discussion
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 from my SharePoint using the http://mysite/_vti_bin/listdata.svc with OData method.
Now I am trying to create a relation ship between IncidentTracker and UserInformationList to get the actual "Created By" and "Modified By", but seem to have been able to connect either to one of the columns.
How do I create a relationship so that I can display both Created By and Modified By in my output table?
CreatedByUser = CALCULATE(VALUES(User[Name]),USERELATIONSHIP(Incident[Createdby],User[User]))
ModifiedByUser = CALCULATE(VALUES(User[Name]),USERELATIONSHIP(Incident[Modifiedby],User[User]))
10 Replies
- Vvelarde
Community Champion
Anonymous
With USERELATIONSHIP in a Dax Measure you can activate relationship between the tables (The active and Inactive)
- Vvelarde
CreatedByUser = CALCULATE(VALUES(User[Name]),USERELATIONSHIP(Incident[Createdby],User[User]))
ModifiedByUser = CALCULATE(VALUES(User[Name]),USERELATIONSHIP(Incident[Modifiedby],User[User]))
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]))
Hey I have a quick question which relates to this.
I have a similar situation as listed and implemented the same DAX expressions. When I try to place the measure on my table it's not letting me. It says a table of multiple values was supplied where a single value was expected.
Could you please help with this. I can give you all the details of my report as we work on it.
