topic Re: Relate a table with two other in the model in DAX Commands and Tips

Relate a table with two other in the model

TSGD2123 — Thu, 16 Mar 2023 09:58:08 GMT

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

Re: Relate a table with two other in the model

tamerj1 — Thu, 16 Mar 2023 10:54:36 GMT

Hi TSGD2123
Please clarify further perhaps with some examples.

Re: Relate a table with two other in the model

TSGD2123 — Thu, 16 Mar 2023 16:24:45 GMT

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!

Re: Relate a table with two other in the model

tamerj1 — Thu, 16 Mar 2023 18:08:01 GMT

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

Re: Relate a table with two other in the model

TSGD2123 — Fri, 17 Mar 2023 07:24:59 GMT

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.