Listing a measure from one table in another

[collinlorbecki]

I have a measure that is a scaler value function based on a filter.  I have another table with a relationship on a unique identifier in which I want to create a calculated column that lists the value of that measure.  I.E. It would be the same in every row.

Here is my measure based on the selected site:

I want it to return this value in the table here: 

[MattAllington]

Calculated columns do not respond to visualisations. How are you planning on using this column?  Can it be done in a measure instead?

[collinlorbecki]

 I'm finding that out the hard way.

I actually detailed my overall goal in another post, but decided to break it down to just my next step because I wasn't getting any replies.  Any thoughts?

[MattAllington]

I replied in the other post