Measure to lookup value in table based on slicer value

[shaunparsons66]

I have the below table loaded into PowerBI, with a slicer on the canvas for 'Site Name'.

I want to create a measure that looksup the country associated with whatever site name is selected in the slicer.

Any ideas on how I can do this?

Site Name	Country	Region
Site A	UK	EMEA
Site B	USA	Americas
Site C	France	EMEA
Site D	Germany	EMEA

[MahyarTF]

Hi,

I am a bit misunderstanding, 

Do you want to show the Country when the SiteName is selected in the slicer?

if yes, why you are looking for Lookup, it is a simple slicer on a particular column.

if No, would you please let me know what your mean is (with a sample Please )?

[Ale]

If you have only 1 Country for each Site Name, then you don't need any logic behind it. Just use the Country field and it will show the respective country whenever a particular site is selected in the slicer.

[shaunparsons66]

Hi - I massively simplified the table, the real table has 400 sites and about 85 countries. So would still need the logic I'm seeking, unfortunately. Also, it needs to be captured in a measure, because I intend on targeting that measure in subsequent measures.

[Ale]

The number of sites won't matter here as long as 1 site has only 1 country assigned to it. The issue would be only in case there are more than 1 country for the same site (which I think it's not the case here).

With that said, again, you don't need a sophisticated logic. Simply create a measure that takes the [Country] field.

[shaunparsons66]

How do I do that? I've tried FIRSTNONBLANKVALUE but can't get it working

[Ale · Accepted solution]

Try:

Selected Country = SELECTEDVALUE('Table'[Country])

If that doesn't work, could you share a demo .Pbix?