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

     

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 ðŸ™‚   

lorenz0210's avatar
lorenz0210
Icon for Helper I rankHelper I
6 years ago

Hi. 

 

I am new to power bi. I'm not sure if I have the same issue. I'm trying to connect create a relationships from 2 reports between a target vs. the actual. I am not getting any error but the results shows the sum of all target.

 

Here is my dax formula: 

 

Target =
CALCULATE(
SUM(Target),
USERELATIONSHIP('Region[UserName],'Actual'[Username]
))
 
Maybe I am doing something wrong. 
 
Hoping for your assistance. 
 
Thank you.