My scatter plot doesn't work

[Anonymous]

Hey everyone, 

My scatter plot doesn't work accordingly I think it might be a relationship problem, could any of you try to solve the issue and explain me what the problem was? 

Here is the file, no confidential information inside: 

Scatter Plot 

[mahoneypat · Accepted solution]

It would be better to change your model to create a country table with country code column that connects to your tables with country data.  However, this measure expression works with your current model.  Use it on your Y axis, format it as a %, and change the Y max back to auto.

Unemp Rate Treatas =
CALCULATE (
    AVERAGE ( 'Unemployment Rate'[Unemployment Rate] ),
    TREATAS (
        VALUES ( 'GDP Per Capita'[Country Code] ),
        'Unemployment Rate'[Country Code]
    )
)

Regards,

Pat