Forum Discussion

MikeSwe's avatar
MikeSwe
Regular Visitor
4 years ago
Solved

Help with multiple Power BI relations between the same table

Hi,   I am completely new to Power BI and after several days of searching online and experementing I have not been able to solve this and turn to this community for help.   I have a SharePoint li...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi MikeSwe 

     

    Download sample PBIX file

     

    You can create 2 measures to return the names

     

     

    Project Lead = CALCULATE(MAX('Users'[UserName]), FILTER('Users', SELECTEDVALUE(Projects[ProjectLeadID]) = 'Users'[UserID]))

     

     

     

    Project Manager = CALCULATE(MAX('Users'[UserName]), FILTER('Users', SELECTEDVALUE(Projects[ProjectManagerID]) = 'Users'[UserID]))

     

     

     

    Regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
4 years ago

Hi MikeSwe 

 

Download sample PBIX file

 

You can create 2 measures to return the names

 

 

Project Lead = CALCULATE(MAX('Users'[UserName]), FILTER('Users', SELECTEDVALUE(Projects[ProjectLeadID]) = 'Users'[UserID]))

 

 

 

Project Manager = CALCULATE(MAX('Users'[UserName]), FILTER('Users', SELECTEDVALUE(Projects[ProjectManagerID]) = 'Users'[UserID]))

 

 

 

Regards

 

Phil

  • MikeSwe's avatar
    MikeSwe
    Regular Visitor
    4 years ago

    Thank you very much, it worked perfectly.