Hi all,
Getting this error again:
The table which points to the "country" table has a calculated column as following:
The "country" table:
What am I missing here??
1 ACCEPTED SOLUTION
@Anonymous @Niels_NL : I could get more details by creating the relationship (or trying) from the 'manage relationship' button :
What I really don't get is that the Continent>Country column has unique values... Would it be because of the continent column, as values are not unique??
Below is the full table,
Thanks for helping...
ContinentCountry
| Asia | Afghanistan |
| Europe | Albania |
| Africa | Algeria |
| Oceania | American Samoa |
| Europe | Andorra |
| Africa | Angola |
| South America | Anguilla |
| Oceania | Antarctica |
| South America | Antigua and Barbuda |
| South America | Argentina |
| Asia | Armenia |
| South America | Aruba |
| Oceania | Australia |
| Europe | Austria |
| Asia | Azerbaijan |
| South America | Bahamas |
| Asia | Bahrain |
| Asia | Bangladesh |
| South America | Barbados |
| Europe | Belarus |
| Europe | Belgium |
| South America | Belize |
| Africa | Benin |
| South America | Bermuda |
| Asia | Bhutan |
| South America | Bolivia |
| Europe | Bosnia and Herzegovina |
| Africa | Botswana |
| Oceania | Bouvet Island |
| South America | Brazil |
| Oceania | British Indian Ocean Territory |
| South America | British Virgin Islands |
| Asia | Brunei |
| Europe | Bulgaria |
| Africa | Burkina Faso |
| Africa | Burundi |
| Asia | Cambodia |
| Africa | Cameroon |
| North America | Canada |
| Africa | Cape Verde |
| South America | Cayman Islands |
| Africa | Central African Republic |
| Africa | Chad |
| South America | Chile |
| Asia | China |
| Oceania | Christmas Island |
| Oceania | Cocos [Keeling] Islands |
| South America | Colombia |
| Africa | Comoros |
| Africa | Congo - Brazzaville |
| Africa | Congo - Kinshasa |
| Oceania | Cook Islands |
| South America | Costa Rica |
| Europe | Croatia |
| South America | Cuba |
| Europe | Cyprus |
| Asia | Cyprus |
| Europe | Czech Republic |
| Africa | Côte d’Ivoire |
| Europe | Denmark |
| Africa | Djibouti |
| South America | Dominica |
| South America | Dominican Republic |
| Europe | East Germany |
| South America | Ecuador |
| Africa | Egypt |
| South America | El Salvador |
| Africa | Equatorial Guinea |
| Africa | Eritrea |
| Europe | Estonia |
| Africa | Ethiopia |
| South America | Falkland Islands |
| Europe | Faroe Islands |
| Oceania | Fiji |
| Europe | Finland |
| Europe | France |
| South America | French Guiana |
| Oceania | French Polynesia |
| Oceania | French Southern Territories |
| Africa | Gabon |
| Africa | Gambia |
| Asia | Georgia |
| Europe | Germany |
| Africa | Ghana |
| Europe | Gibraltar |
| Europe | Greece |
| South America | Greenland |
| South America | Grenada |
| Europe | Guadeloupe |
| Oceania | Guam |
| South America | Guatemala |
| Europe | Guernsey |
| Africa | Guinea |
| Africa | Guinea-Bissau |
| Europe | Guyana |
| South America | Haiti |
| Oceania | Heard Island and McDonald Islands |
| South America | Honduras |
| Asia | Hong Kong |
| Europe | Hungary |
| Europe | Iceland |
| Asia | India |
| Asia | Indonesia |
| Asia | Iran |
| Asia | Iraq |
| Europe | Ireland |
| Europe | Isle of Man |
| Asia | Israel |
| Europe | Italy |
| South America | Jamaica |
| Asia | Japan |
| Europe | Jersey |
| Asia | Jordan |
| Asia | Kazakhstan |
| Africa | Kenya |
| Oceania | Kiribati |
| Asia | Kuwait |
| Asia | Kyrgyzstan |
| Asia | Laos |
| Europe | Latvia |
| Asia | Lebanon |
| Africa | Lesotho |
| Africa | Liberia |
| Africa | Libya |
| Europe | Liechtenstein |
| Europe | Lithuania |
| Europe | Luxembourg |
| Asia | Macau SAR China |
| Europe | Macedonia |
| Africa | Madagascar |
| Africa | Malawi |
| Asia | Malaysia |
| Asia | Maldives |
| Africa | Mali |
| Europe | Malta |
| Oceania | Marshall Islands |
| Europe | Martinique |
| Africa | Mauritania |
| Africa | Mauritius |
| Africa | Mayotte |
| Europe | Metropolitan France |
| South America | Mexico |
| Oceania | Micronesia |
| Europe | Moldova |
| Europe | Monaco |
| Asia | Mongolia |
| Europe | Montenegro |
| South America | Montserrat |
| Africa | Morocco |
| Africa | Mozambique |
| Asia | Myanmar [Burma] |
| N/A | N/A |
| Africa | Namibia |
| Oceania | Nauru |
| Asia | Nepal |
| Europe | Netherlands |
| South America | Netherlands Antilles |
| Asia | Neutral Zone |
| Oceania | New Caledonia |
| Oceania | New Zealand |
| South America | Nicaragua |
| Africa | Niger |
| Africa | Nigeria |
| Oceania | Niue |
| Oceania | Norfolk Island |
| Asia | North Korea |
| Oceania | Northern Mariana Islands |
| Europe | Norway |
| Asia | Oman |
| Asia | Pakistan |
| Oceania | Palau |
| Asia | Palestinian Territories |
| South America | Panama |
| Oceania | Papua New Guinea |
| South America | Paraguay |
| Asia | People's Democratic Republic of Yemen |
| South America | Peru |
| Asia | Philippines |
| Oceania | Pitcairn Islands |
| Europe | Poland |
| Europe | Portugal |
| North America | Puerto Rico |
| Asia | Qatar |
| Europe | Romania |
| Europe | Russia |
| Africa | Rwanda |
| Africa | Réunion |
| South America | Saint Barthélemy |
| Africa | Saint Helena |
| South America | Saint Kitts and Nevis |
| South America | Saint Lucia |
| South America | Saint Martin |
| South America | Saint Pierre and Miquelon |
| South America | Saint Vincent and the Grenadines |
| Oceania | Samoa |
| Europe | San Marino |
| Asia | Saudi Arabia |
| Africa | Senegal |
| Europe | Serbia |
| Europe | Serbia and Montenegro |
| Africa | Seychelles |
| Africa | Sierra Leone |
| Asia | Singapore |
| Europe | Slovakia |
| Europe | Slovenia |
| Oceania | Solomon Islands |
| Africa | Somalia |
| Africa | South Africa |
| Oceania | South Georgia and the South Sandwich Islands |
| Asia | South Korea |
| Europe | Spain |
| Asia | Sri Lanka |
| Africa | Sudan |
| South America | Suriname |
| Europe | Svalbard and Jan Mayen |
| Africa | Swaziland |
| Europe | Sweden |
| Europe | Switzerland |
| Asia | Syria |
| Africa | São Tomé and Príncipe |
| Asia | Taiwan |
| Asia | Tajikistan |
| Africa | Tanzania |
| Asia | Thailand |
| Asia | Timor-Leste |
| Africa | Togo |
| Oceania | Tokelau |
| Oceania | Tonga |
| South America | Trinidad and Tobago |
| Africa | Tunisia |
| Asia | Turkey |
| Asia | Turkmenistan |
| South America | Turks and Caicos Islands |
| Oceania | Tuvalu |
| Oceania | U.S. Minor Outlying Islands |
| North America | U.S. Virgin Islands |
| Africa | Uganda |
| Europe | Ukraine |
| Europe | Union of Soviet Socialist Republics |
| Asia | United Arab Emirates |
| Europe | United Kingdom |
| North America | United States |
| South America | Uruguay |
| Asia | Uzbekistan |
| Oceania | Vanuatu |
| Europe | Vatican City |
| South America | Venezuela |
| Asia | Vietnam |
| Oceania | Wallis and Futuna |
| Africa | Western Sahara |
| Asia | Yemen |
| Africa | Zambia |
| Africa | Zimbabwe |
| Europe | Åland Islands |
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
