Calculate Formula across Multiple Tables

[Anonymous]

I am new to Power BI and need some help. 

I have 4 tables and I need to do a bar chart showing how many records in each table. Notes: The same ID can exist in multiple tables. 

tblChair

tblComponents

tblCosmetics

tblHardware

Bar Chart example:

[Ashish_Mathur · Accepted solution]

Hi,

Do all tables have the same structure?  If yes, then why cane we not append data from all tables into one table and then create our desired visual.  If they do not have the same structure, then which is the common column in all 4 datasets?

[Anonymous]

Thank you so much. I apologize but all of this is new to me. This worked great. I did the Append and am able to get my data now. 

[Ashish_Mathur]

You are welcome.