FIRST DATA FIELD IS BASED FROM THE SECOND DATA FROM PICKING ONE OF THE TWO DIFFERENT DIMENSIONS

[MarvelousMar]

Hi Everyone,

I have an issue that seems easy, but it is a pain. 

I have a field name "Region" and Active Dimension1 with two different fields named "Countries Table 1" and "Countries Table 2".

When I select the dimension of "Countries Table 1" the "Region" field should reflect those numbers. When I select "Countries Table 2" then the "Region" field should reflect those numbers. 

I have used these functions below, but none have changed the numbers for the "Region" field.

= dual (REGION, ActiveDimension1)

= if(WildMatch(GetCurrentSelections(ActiveDimension1),'Countries Table 1'), [Countries Table 1], REGION)

=  dual (REGION, if(GetCurrentSelections(ActiveDimension1) = 'Countries Table 1', [Countries Table 1], [Countries Table 2]) )

The Region field represent sections like Asia, North America, Europe, etc.

The Countries Table 1 and 2 lists individual countries but hold different dataset. 

Any help is greatly appreciated. Thanks!