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

Outer Join in Direct Query

Hi Friends

I am trying to come up with final output as in fig below. Please note that Table 2 count is  a measure created in Table 2. I wana have outer join setup so that always Final output should display all Routes form Table 1 as shown below

I could do this in Import query by creating columns and variables but as Directquery DAX does not support calculate hence I am facing issue 

 

OuterJOin.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Outer Join in Direct Query

Hi @srlabhe123,

 

You need to enable the Measure for the direct query and in that way you can make them work without making the calculations on your query but on the desktop part:

 

Options.png

 

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




1 REPLY 1
Super User
Super User

Re: Outer Join in Direct Query

Hi @srlabhe123,

 

You need to enable the Measure for the direct query and in that way you can make them work without making the calculations on your query but on the desktop part:

 

Options.png

 

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!