Outer Join Does Not Works

[srlabhe123]

Hi All,

I have data in form of below 2 tables:

Table 1

Table 2

I joined these 2 tables with all data from table 1 and matching data from table 2. 

When I try to pull Table1.Metric and Table.Count it just gives same out put as Table 2.

Rather I am expecting as below

Expected Output:

[Aron_Moore · Accepted solution]

Couple ways to do this:
Click "Show items with no data", that'll bring in blanks and not zeros.

Probably best to create a measure that sums the counts from table 2 and use that instead of the related column.

[srlabhe123]

ohh that was easy one....

[Anonymous]

Can you please explain how did you join?

Thansk
Raj