Help With Visuals from Unpivot

[lennardsomera]

Hoping someone can help. 

I have the following fact table 

Title	Attribute	Value
Project A	Project Lead	Staff1
Project A	Supporting Lead	Staff2
Project B	Project Lead	Staff3
Project B	Supporting Lead	Staff2
Project C	Project Lead	Staff2
Project C	Supporting Lead	Staff3

and the below dimension table 

StaffID	StaffName
Staff1	John
Staff2	Mary
Staff3	Andrew

How can I produce the below visual when I have only one field to work on the dimension table?  

Project Name	Project Lead	Supporting Lead
Project A	John	Mary
Project B	Andrew	Mary
Project C	Mary	Andrew

[lbendlin · Accepted solution]

One way is to pull in the dimension attribute into the fact table as a calculated column

see attached

[v-tangjie-msft · Accepted solution]

Hi @lennardsomera ,

First of all thank you lbendlin  for the quick reply and solution.
Apart from that you can also try the following calculation column:

StaffName = LOOKUPVALUE('Dimension'[StaffName],'Dimension'[StaffID],'Fact'[Value])

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[lbendlin · Accepted solution]

One way is to pull in the dimension attribute into the fact table as a calculated column

see attached