Multiple images for different columns in a table pointing to a single table containing Image URLs

[caznaran]

Hi, I'm trying to set up a Dashboard contaning specific information for each of our projects. I wanted to show the pictures of the team via Image URLs and it worked, at least for the Project Sponsor.

I wanted to also show the pictures of the Project Manager and Functional Leader. But I cannot set up the relationship to work from these columns in my project table to a single Image URL field (thumbnailPhoto) from the central AD table.

Any help will be really appreciated

[amitchandak]

Can you check if there other relationships or bidirectional relations with other tables, creating a loop?

Can you share complete schema diagram

[caznaran]

Here you have it. The schema is simple, only 2 tables, with the AD table containing the thumbnail photo from the Active Directory.

[v-chuncz-msft]

@caznaran 

You may try function USERELATIONSHIP and LOOKUPVALUE in DAX.

[caznaran]

Thanks @v-chuncz-msft , can you give me a hint?

I'm trying to create a measure like this:

PMPhoto = CALCULATE(LOOKUPVALUE(AD[thumbnailPhoto],AD[displayName],'Projects 2020'[Project Manager]),USERELATIONSHIP('Projects 2020'[Project Manager],AD[displayName]))

But apparently I'm using an incorrect syntax.