Forum Discussion

TSGD2123's avatar
TSGD2123
Icon for Helper I rankHelper I
3 years ago

Relate a table with two other in the model

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

double relationship table dax

4 Replies

    • TSGD2123's avatar
      TSGD2123
      Icon for Helper I rankHelper I
      3 years ago

      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's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        3 years ago

        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