Cannot create active relationship - Have to create another table?

Hi there,

Got a issue that is: an active relationship cannot be created, please refer to following screen capture.

Following active relationships have been created:

from Domains[Domain] to Queries_byPage[Domain]

from Queries_Properties[Query] to Queries_byPage[Query]

Now, I would like to create active relationship between Domains[Domain] and Queries_Properties[Domain] to get filtered data and visualization no matter slicer, filter, choose-on-visual all same affected.

Get following error

Question:

- Do I have to create another table contains Query and create active relationship to Queries_Properties[Query] and Queries_byPage[Query], THEN create active relationship between Domains[Domain] and Queries_Properties[Domain]?

- Hopefully there is other way to do so since there are over hundreds million rows inside.

Background:

Queries_byPage: DataSource from folder Queries_RAW, to get all data and metrics

Queries_Properties: DataSource from same folder above, proceeded to get distinct (de-duplicated) Query, then use DAX proceeds to get queries properties e.g. counts of word, domain belonging, branded/non-branded, etc.

Domains: DataSource: manually input, unique values contained in all other datasource, e.g. domain1, domain2.

Please help to advise.

Thanks in advance.

H