Please help me on achiving below scenario
Hi newellaa ,Thanks for the quick reply, you are in the right direction.
Hi @shafeeqva ,
The Table data is shown below:
Please follow these steps:
1.Create relationships between tables
2.Use the following DAX expression to create a column
Column = RELATED(City[City])RELATED function (DAX) - DAX | Microsoft Learn
3.Final output
Best Regards,
Wenbin Zhou
Hi newellaa ,Thanks for the quick reply, you are in the right direction.
Hi @shafeeqva ,
The Table data is shown below:
Please follow these steps:
1.Create relationships between tables
2.Use the following DAX expression to create a column
Column = RELATED(City[City])RELATED function (DAX) - DAX | Microsoft Learn
3.Final output
Best Regards,
Wenbin Zhou
From the model view in Power BI desktop you could create a join between the city and country tables on city.
Helpful resources
Fabric Data Days 2026
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Power BI Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
