Forum Discussion

Josh1994's avatar
Josh1994
Icon for Helper II rankHelper II
2 years ago

Seeking Help with Power BI: Linking Tables in DirectQuery Mode

Hello All!

 

I hope all is well with you 🙂

I was wondering if anyone has a solution to the issue i am facing.

 

I have one table named 'Locations' with a column named 'Location'.


I also have a table names 'Workorder' with a column named 'Location'.

 

I am trying to visualise the number of locations in the 'Location' table that are also visible in the 'Workorder' tab.

 

Using filters i can then show how many Locations of a certain criticality have a work order in an open status.


I am unsure how to link the two in a way that works, and the few dax expressions i have written have not worked.

 

Just to add i am using Direct query, and there could be several examples of the same 'location' in the 'Workorder' Table


Appreciate any tips you are able to give

Need Help

4 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    2 years ago

    Hi Josh1994 

    You should still be able to create relatioinships even if the storage mode is DQ. Have you tried creating one?

    • Josh1994's avatar
      Josh1994
      Icon for Helper II rankHelper II
      2 years ago

      Hi!

      Thanks for your reply

      Im not puttign ym problem into words so well

       

      I can link them, essentially what im trying to do is have the first list of complete locations Table Locations column locations, To compare against Workorder Locations And return Yes or No so i can make a % of total locations with work orders

  • Josh1994's avatar
    Josh1994
    Icon for Helper II rankHelper II
    2 years ago

    Hi,

    I have tried to visualise what i am trying to achieve abit better.

    The issue im havign is the multiple locations that are possible aginst a work order