cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
srlabhe123 Member
Member

Outer Join Does Not Works

Hi All,

I have data in form of below 2 tables:

Table 1

MEtricSeq.JPG

 

Table 2

MEtricSeq1.JPG

 

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:

MEtricSeq2.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Aron_Moore Established Member
Established Member

Re: Outer Join Does Not Works

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

Capture.PNG

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

View solution in original post

3 REPLIES 3
rajendran Super Contributor
Super Contributor

Re: Outer Join Does Not Works

Can you please explain how did you join?

 

Thansk
Raj

Aron_Moore Established Member
Established Member

Re: Outer Join Does Not Works

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

Capture.PNG

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

View solution in original post

srlabhe123 Member
Member

Re: Outer Join Does Not Works

ohh that was easy one....

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)