Creating a visual combing 3 different tables with similar data

Hi ank1997 ,

If you want to show all data about states on the map, ideally you can create a calculated table like this to extract the state column as a single table and create relationships based on the state between these tables:

State table = 
DISTINCT(
    UNION(
        DISTINCT('Table1'[State]),
        DISTINCT('Table2'[State]),
        DISTINCT('Table3'[State])
    )
)

By the way, notice that there are also School columns on table1 and table3 so you need to consider it first because the final table would be like this:

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.