Filtering table based on another table

[dschloyer]

I'm new to BI, and trying to display results in two tables.  The first table has a regional view that reports values and % at each region:

Table 1

The second table shows a detailed view by country.  When clicking on Region in the first table, I can filter the 2nd table, but the calculations are wrong.  Instead of showing the values for each country, it repeats the Regional values:

Is there a way to re-calculate the fields to show the values in each country?  Thank you

[v-frfei-msft]

Hi @dschloyer ,

Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

[Anonymous]

Are you able post a picture of your relationship table? Chances are the tables are not "talking" to one another which is why you are getting incorrect calculations.