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

     

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

  • lorenz0210's avatar
    lorenz0210
    Helper 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.