PBI Indirect Relationship Issues

[farhandsome]

Hi all,

I am having an issue with filtering of my tables. Here is the scenario:

I have three tables - one is populated by the production floor, one is daily order schedule, and one is a reference table for build times. Here is the relationship below:

The DBS is the real-time production floor data which is identified by the Master Build Schedule (Stryker Daily), and then this is cross-referenced to a master sheet (Booms Routing Master) that identifies each order by it's material and spits out an estimated build time for that order delineated by Workstation. 

The problem comes at the workstation delineation. Check this image below:

As you can see, this is a subassembly of one order at station "S030". However, it does not recognize that relationship when referencing the build time table and every single station is being populated in the sum of build times. I only want the "S030" build time for this specific order.

The problem lies in the fact that these are SQL data tables thru DirectQuery. I cannot change to import based on the use case, and that keeps me limited in terms of DAX and data manipulation. Is there anyway to make an indirect relationship?

Thanks,

Farhan

[v-lid-msft]

Hi @farhandsome ,

Have your issue be resolved?Could you please provide more details about it If it still not be soleved? Please don't have any Confidential Information or Real data in your reply.

Best regards,

[PaulDBrown]

@farhandasome
If by indirect you mean virtual you can use the TREATAS function, which in effect creates a virtual relationship between two tables which share a common field

[v-lid-msft]

Hi @farhandsome ,

It seems there are two Workstatios field used in this table visual, Could you please calify the field used in table visual come from which table? Are there any Many to Many relationship between each tables?

Best regards,