an active set of indirect relationships already exist between these tables

[MartynasBI]

Hi,

I have created a preliminary overview of a data model in Excel.

Tables 1 through 4 (starting with text 'upd'...) are fact tables, whereas 'Date', 'Analyst' and 'Reviewer' tables are dimension tables.

I'd like to slice the 'upd'... tables data using slicers from Date, Analyst or Reviewer tables.

For instance, i'd like to see how many 'error-count' errors there were across the 4 'upd' tables filtering by the single 'Analyst' table. However, I get an error saying that an active set of indirect relationships already exist between these tables.

Using USERELATIONSHIP formulas in DAX would seem to be inefficient in this particular case, as there will be numerous metrics that I would like to slice/filter, not just 'error-count'. 

Excel preliminary view model

Power BI Desktop model view

Many thanks in advance

[lbendlin]

Your date table is a dimension. Relationships need to be 1:* single direction.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523