Relate a table with two other in the model

[TSGD2123]

Hello! Here is a simplified data model of my case:

Basically I hace 2 fact tables, one with services, the other with task from the services. Both have their own structure so i need each service and task associated with their structure, so I can have a 2 diferent StrDesc filters, one for Tasks and one for Services. Is there a way to do it with dax so I can avoid duplicate Structure Table?

Thanks a lot in advance

[tamerj1]

Hi @TSGD2123 
Please clarify further perhaps with some examples.

[TSGD2123]

Hello @tamerj1 

This is a sample:

Services and Tasks should be independently connected to Structure table so that when I filter by StrDesc, for instance Structure 1, I see Services SER_ and SER_J, and Task A.

What I'm looking is something like USERELATIONSHIP but applied to a field rather than a measure.

Thanks!

[tamerj1]

@TSGD2123 

It depends on what exactly are you planning to achieve. The sample that you have provided most probably doesn't reflect the reality. I can guess that for each StrDesc there are multiple SERVID related to it. And each SERVID relates to multiple TASKID

[TSGD2123]

Each TASKID belongs to only one SERVID, each SERVID has one or more TASKID. Both each SERVID and TASKID has only one structure (STRID). 

I'm just looking for a way to avoid duplicating the STRUCTURES table and make it cleaner, more efficient.