Creating a visual combing 3 different tables with similar data

Ideally, you should have a table with a column of all of the unique states, or more likely schools, and that column should have a one to many relationship with your fact table. That way, you are able to display and all states by filtering on the unique column.

 

--Nate

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.