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
Solved! Go to Solution.