Forum Discussion
Creating relationships to multiple columns and displaying data
CreatedByUser = CALCULATE(VALUES(User[Name]),USERELATIONSHIP(Incident[Createdby],User[User]))
ModifiedByUser = CALCULATE(VALUES(User[Name]),USERELATIONSHIP(Incident[Modifiedby],User[User]))
Community ChampionAnonymous
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]))
- Vvelarde
Your relationship look lie this;?
Created and Modified related to User column in user table
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
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.
