Forum Discussion

alderete-tomas's avatar
alderete-tomas
Frequent Visitor
3 years ago
Solved

Join paths are expected to form a tree

I have 5 tables: Calendar (C), Sales (S), Profit Center Attributes (PC), Employees (E), Attendance (A). I have them joined as follows:  1. C[Date] (1:m) E[First Day of Month] 2. C[Date] (1:m) A[Da...
Need Help
  • alderete-tomas's avatar
    alderete-tomas
    3 years ago

    It's been solved by keeping the relationship bewteen E and A inactive (but existing), then applied in the measure I needed "CROSSFILTER(PC[Center], Employees[Center], OneWay_LeftFiltersRight))".

     
    Thanks for your time, indeed.
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi alderete-tomas ,

According to your description, I create a sample. As you can see, if you already create relationships C>A and C>E, we can't create active relationship between A and E any more.  As it will creates a closed-loop relationship, which is not allowed in Power BI.

The error message said you have two paths from table "Attendance" to table "Profit Center Attributes", Power BI don't know which path to choose. I suggest you delete the relationship between A and E.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • alderete-tomas's avatar
    alderete-tomas
    Frequent Visitor
    3 years ago

    Thanks for yor time taking a look into this. 
    Want to make a point: the relationship between E and A is because Employees contains personal info, DNI, working or dismissed, first day of month, etc., and this table changes from month to month; while Attendance is a daily personal information containing DNI, Date, states of attendance, etc. This relationship is inactive, but exists and to "active it", in a DAX line it's used "userelationship".