Is it possible to merge two different table visuals with a common column?

[Anonymous]

Hi, I have two tables each having two columns. One of them being facility which is common to both. The other one is # of entries and # of exits. I am trying to merge this into a single table. 

Facility	# of entries

Facility	# of exits

The # of entries and exits are values from the same column with different filters and aggregation types. Please help. I need the resulting table to look like this.

Facility	# of entries	# of exits

[amitchandak]

Create a common Facility dimension table and join with both of them.

Facility Dim = distinct(union(all(table1[Facility]),all(table2[Facility])))

Then use common dimesnion to get desired results.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

[Anonymous]

@amitchandak  Thank you for the reply. I am trying to merge table VISUALS and not actual tables. If I am creating a new table, where would I do it, I am pulling data from SQL server. Kindly answer in detail if possible as I am a beginner here. 

[amitchandak · Accepted solution]

You Measure are coming from the same column with filter, are you using the visual level filter to display those. If yes then use measure filter

example

# count = calculate(count(table[Col1]),table[Col2] ="ABC")

# count = calculate(count(table[Col1]),table[Col2] ="DEF")