Table Relationships

[ghutchins]

Got a newbie question about how to relate tables together.

I have ~15 tables in my data viz and about the only common column between them all is my designator for 'Site'  which is either a Power Query calculation or data pulled from the data source.  When i started there were two tables so i just made a relationship between those two sites using 'Site'.  As i was tasked to add more data i just kept relating 'Site' in the first table to 'Site' in all the new tables.

At this point i am getting some strange behaviour that I dont understand.  It occured to me that maybe in need a ?Site Table? to relate all the other tables to instead of the first data table.  I think sometimes a "Data Table" is used do the same thing.

My question, would it be benefical to create this ?Site Table? with one column that had all the sites i use and point all the other tables to it?

[ghutchins]

@amitchandak I got an email asking if this is an acceptable solution.  It very well may be but I still have quesiton above since I am so new at PBI

[ghutchins]

@amitchandak What does "create as a dimension" mean?  do i create a table with all the sites then make a 1-many realtionship between this new table and the other ~15 existing tables?

[amitchandak]

@ghutchins , Based on what  I got, If you have multiple tables having sites, you need to create it has dimension

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

You can do same in power query too